Using an update query, but updating +2 weeks...

[AudiA4_20T]

Hi everyone,

I'm looking to take a date from one table "8/1/2011 4:11:41 PM" and update it to another sheet, but the date two weeks from the one posted.

So, I would take: 8/1/2011 4:11:41 PM and I would want 8/15/2011 4:11:41 PM on the updated sheet.

Is there a criteria I can add to do this? And while we're on that topic, is there any main list of Access criterias? That would be extremely helpful

TIA,


Clint

[RuralGuy]

Look up DateAdd() in VBA Help.

[rpeare]

what you're asking about is not a criteria, a criteria limits how you view a particular dataset. You're asking how to transform an existing piece of data, and you would do that with an update query (or an add record query) and use the dateadd function just as RG has suggested.