ACCESS: Microsoft 2010 RECORD or SAVE

RINGO STARR · August 2nd, 2011, 08:20 AM

My problem is that a lot of fields in my access database retain the same details
and only 4 or more fields are changed.

I would like to know if I can use some other method whereby I can either modify an existing record or save as a new record with the altered fields and existing fields.

Please Help thanks

Ringo Starr

gjgriffith · August 2nd, 2011, 01:31 PM

Hello RINGO STARR,

I saw your post here and wanted to say thank you for posting your question. Specifically, you said:

Quote:

I would like to know if I can use some other method whereby I can either modify an existing record or save as a new record with the altered fields and existing fields.

So, I would suggest just making a copy of the record, modifying the necessary fields, and then saving the new record. Does this make sense? Will this work for your situation?

Please let me know if there is anything else I can do to help!

Thanks,

RINGO STARR · August 3rd, 2011, 05:52 AM

Quote:

Originally Posted by gjgriffith

Hello RINGO STARR,

I saw your post here and wanted to say thank you for posting your question. Specifically, you said:

So, I would suggest just making a copy of the record, modifying the necessary fields, and then saving the new record. Does this make sense? Will this work for your situation?

Please let me know if there is anything else I can do to help!

Thanks,

Thanks Sir Gjgriffith,

Actually i have this FORM and only the mileage field (record) i changed. but i could not make the report from the previous input instead i erase them. how can i make a report in weekly or monthly basis report? Thanks in advance.