DateAdd Function

[armyofdux]

I am trying to get the right syntax to use the DateAdd Function. Here goes

I have a field in the tbl Student Data titled DATE_ADDED. I have an append query setup to add data to a another table (Booking).. I can't get the syntax right to make it work.

This is what I have. I want it to append the data to matching fields in the booking table meeting the following criteria of 10 seconds after it is added.

>DateAdd("s",10,[DATE_ADDED])



It recognizes it as proper syntax because it doesnt error out but it doesnt do anything with respect to appending data.

[orange]

You seem to be adding 10 seconds to Date_Added -- is that what you meant to do?

[armyofdux]

No, I want to append data based on it being older than 10 seconds since it was created.

Maybe more like this... but I am not getting any results. "WHERE">DateAdd("s",10,Date())

[orange]

You will need something along the lines of

vba:
If ( Datediff("s", Date_added, Now()) >10 ) then
do something

or with immediate iif

IIF( Datediff("s", Date_added, Now() >10 ), Truepart,Falsepart)

[armyofdux]

I can't get the syntax to work right, is there any easy way to take data entered into a form and then press a button to copy the like fields to another table. I know I just described an append query but everytime I do it I get no results copied. It runs but it just doesnt produce.

[June7]

I think orange's expression has misplaced ) :

IIf(Datediff("s", Date_added, Now()) >10, Truepart, Falsepart)

[orange]

Thanks June!

[armyofdux]

Is that syntax able to be used as a criteria in a query? The Immeadiate IF syntax is right but the truepart/falsepart threw me a curveball. I already know what I want it to do and that is copy the selected fields in accordance with the building of the append query. Am I missing something?

[armyofdux]

.....errors

[rpeare]

put a field in your append query:

Indicator: IIF(Datediff("s", Date_added, Now()) >10 , 1, 0)

set the criteria of this field to 1

Your query should show only records that are older than 10 seconds

[June7]

Why are you 'copying' data? What do you mean by 'copy the selected fields'?

If you just need to append data from form into a table, why do you need filter criteria? I really don't understand your criteria of 10 seconds. Copy a record to another table 10 seconds after it was created?

[armyofdux]

Why are you 'copying' data? What do you mean by 'copy the selected fields'?

If you just need to append data from form into a table, why do you need filter criteria? I really don't understand your criteria of 10 seconds. Copy a record to another table 10 seconds after it was created?

The reason for the ten seconds is so that I don't get a litany of popups about records that are already present. Thus the ten seconds would only give me that particular record. Unless there is an easier way to do it.

[June7]

Easier way is to use unique record ID as criteria.