A aura1commandos New member Local time Yesterday, 16:45 Joined Apr 11, 2013 Messages 8 Apr 11, 2013 #1 i wanna create Query , i have in it time enter and time sortie , and i want see just the ones that enter and not get out yet
i wanna create Query , i have in it time enter and time sortie , and i want see just the ones that enter and not get out yet
G Galaxiom Super Moderator Staff member Local time Today, 09:45 Joined Jan 20, 2009 Messages 12,895 Apr 11, 2013 #2 Assuming you have fields called [time enter] and [time sortie] on each record you would use an Is Null condition on [time sortie] to return those that have no entry in that field.
Assuming you have fields called [time enter] and [time sortie] on each record you would use an Is Null condition on [time sortie] to return those that have no entry in that field.
A aura1commandos New member Local time Yesterday, 16:45 Joined Apr 11, 2013 Messages 8 Apr 11, 2013 #3 like you say
A aura1commandos New member Local time Yesterday, 16:45 Joined Apr 11, 2013 Messages 8 Apr 11, 2013 #4 i have not enter any information on [time sortie] vide
A aura1commandos New member Local time Yesterday, 16:45 Joined Apr 11, 2013 Messages 8 Apr 11, 2013 #5 i want get the ones that enter to my garage and have not sortie yet by date or time
G Galaxiom Super Moderator Staff member Local time Today, 09:45 Joined Jan 20, 2009 Messages 12,895 Apr 11, 2013 #6 In the query designer, write: Is Null in the Criteria row under the [time sortie] field. BTW. I am guessing you are having trouble with English. Where are you from?
In the query designer, write: Is Null in the Criteria row under the [time sortie] field. BTW. I am guessing you are having trouble with English. Where are you from?
A aura1commandos New member Local time Yesterday, 16:45 Joined Apr 11, 2013 Messages 8 Apr 11, 2013 #7 am from algeria , thx for the helping
