Append Query

[brucey54]

Hi Folks, is possible to run an Append Query and update a field at the sametime?
i.e. I would like the MealDate field to be incremented by 1, just not sure how to write the code within the query!!!

This is what I have so far!!! not working

MealDate: ([MealDate](Date()+1))

 

[pr2-eugin]

Sorry I am a bit lost, you are adding a record and you want the one of the field (say mealDate) to be Date (i.e. Today's date) plus One?

If that is what you want, use the default value property of the control to be =DateAdd("d", 1, Date())

 

[brucey54]

Hi Paul, yes I would like to append a records to my table with the date field incremented by 1
i.e.

Record I wish to append to my table

Name: Joe Smith
MealDate: 07/11/2012

How I would like the record to be appended to my table

Name: Joe Smith
MealDate: 08/11/2012

 

[pr2-eugin]

Did you get to try this?

If that is what you want, use the default value property of the control to be =DateAdd("d", 1, Date())

 

[brucey54]

Hi Paul, I’ve tried the following:
Expr1: [MealDate]=DateAdd("d",1,Date())
Outcome
Record I wish to append to my table
Name: Joe Smith
MealDate: 07/11/2013
After the Append query is ran
Name: Joe Smith
MealDate: 30/12/1899
The date field should be 08/11/2013

 

[brucey54]

Thanks Pual, Got it to work