Adding a Day to Update Query

[SteveF]

I have an update query that I want to add one day to. Is it straightforward or am I trying to add the date in to the wrong place?

This is what the query looks like at the moment, I just want it to add one day when it updates the table.

tblJob![Closing Date]

Thanks for help.

 

[JamesMcS]

Might need a bit more info than that - are you adding a field to the update query? If you're trying to add data to a table it's an append query you need.

 

[JamesMcS]

Oh I see - you want to do [closingdate]+1? Try that.

 

[SteveF]

Oh I see - you want to do [closingdate]+1? Try that.

Can't be that simple can it? How dumb will I feel if it is...

 

[JamesMcS]

It should work if closingdate is set to be a date/time field.... and no worries that's what this forum's all about!

 

[SteveF]

Ha ha, it works. Sorry, that has to be the dumbest question I've asked so far

 

[JamesMcS]

There should be a top ten on this forum somewhere... I'd occupy 1-9 at the very least!

 

[SteveF]

I feel such a muppet. I tried a couple of searches and it was all SQL strings and tricky stuff, it never occurred to me to try the simple approach.

Thanks for help, thanks for not laughing...

 

[JamesMcS]

Didn't say I didn't laugh kidding, asking questions is how you learn stuff! It might have been different if closingdate wasn't already a date field, then we'd have had to faff around a bit. It might be worth reading up on how Access treats date operations if you're going to get into it any deeper.

 

[SteveF]

The dates don't do anything serious and are not calculated in anywhere, just simple opening and closing dates. I wanted to add one in that place because I have a 'date diff' that counts the days off in the table.

'How do I add one?' 'Have you tried '+1' Steve??' Classic.

 

[JamesMcS]

I'm here all week, try the veal

 

[FrankRomero]

I have a similar issue in that I want to update the month, but I want it the same day (i.e. 7/15/10 to 8/15/10). I also need to update the year in some instances. Any help would be greatly appreciated. thanks.

 

[JamesMcS]

Hi! For more complex date operations, have a look at Dateadd in the help file - it's pretty easy to use.

 

[FrankRomero]

Perfect! thanks!