What value must I use with this?

[Arcadia]

Hello everyone

I hope that someone can help me out with this stupid question :banghead:

By a mistake all departure times and flight number of KL723, after 1 May 2013 have to increase by 1 hour automatic!
So i have to make a query that will do it automatic.

Does someone know the right value i have to type in the critiria box of date and the critira box of time ??

For a screenshot please send me a message!

I really hope someone can help me out

 

[Alansidman]

You should look at doing an update query.

Here's a refresher on the subject: http://www.databasedev.co.uk/update_query.html

 

[plog]

Does someone know the right value i have to type in the critiria box of date and the critira box of time ??

You make it sound like Date and Time are seperate fields, which is a bad idea, you can use the General Date format of the Date/Time field type to get the date and time into one field. If you are using 2 fields to store this data, now is a good instance to store it correctly.

The only criteria you would use is on the flight number field ("KL723") and the date field (>#5/1/2013# or >#1/5/2013# depending on your country).

 

[Arcadia]

Okay.. but that only shows the value date.. I also want to know what to put into the time critira to increase it with one 1 hour.

And i really want to leave them in two separate fields

 

[plog]

And i really want to leave them in two separate fields

Any logic or rationale behind that?

I also want to know what to put into the time critira to increase it with one 1 hour.

Criteria are limiting parameters. You are not limiting the time value, ergo, there is no time criterion.

If your question is 'how do I calculate the new time?', then you want to use the DateAdd function (http://www.techonthenet.com/access/functions/date/dateadd.php)

 

[Arcadia]

I tried this in the data field but it does not work

DateAdd("h";+1;>#1-5-2013#)

 

[Alansidman]

Why don't you post your SQL statement and lets see if we can get you on the right track.

 

[Pat Hartman]

You are trying to combine criteria with the new value. The expressions are separate and go into separate cells in the QBE grid.

 

[Arcadia]

Why don't you post your SQL statement and lets see if we can get you on the right track.

SELECT Vlucht.[Vliegtuig nummer], Vlucht.Datum, Vlucht.Vertrektijd
FROM Vlucht;

 

[Alansidman]

Try this:

UPDATE Flights SET Flights.FTime = DateAdd("h",1,[FTime])
WHERE (((Flights.Flight)="KL723") AND ((Flights.FDate)>#5/13/2013#));