Date Manipulation

[NavyJoe]

Hey guys, working on an awards database now to go along with the spreadsheets ya'll helped me with. I tweeked the old db to my liking. I added two fields in the db. I want the field 1 to be 15 days less than 'Awards Suspense Date' field and field 2 to be 30 days less. How can i do this formula wise? Thanks.

 

[Andrew Fergus]

Hi, try creating an update query adding the 2 new fields, set the "update to" values to "[your award date variable name] - 15" and "[your award date variable name] - 30" (without the quotes). Save and run.

HTH, Andrew.