Querie od date

[vilmarie]

I need obtain in a querie all the information that have a two specific dates. My table have a field called:CurrentDate. I need that my querie call the 07/14/04 and the 07/15/04. How I make these?

 

[lespaul]

should be:

SELECT * FROM MyTable WHERE CURRENTDATE = #7/14/04# OR CURRENTDATE = #7/15/04#

Leslie

 

[PHV]

In the SQL pane:
WHERE CurrentDate IN (#07/14/04#,#07/15/04#)
In the Query Design Window, in the criteria row of the CurrenDate column:
IN (#07/14/04#,#07/15/04#)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[vilmarie]

But if I need that only obtain the person that in the 07/14/04 have a TimeIn>8:00pm and in the 07/15/04 obtain th eprson who have TimeIn<4:00 am
How make the querie:
CurrenDate TimeIn

 

[lespaul]

that's not what you asked for the first time! Why don't you tell us exactly what you are looking to find in the table and what the field names are and ALL the criteria.


Leslie

 

[vilmarie]

Okey, thanks!!! I resolve theese!!!! Thanks

 

[PHV]

Something like this ?
WHERE (
(CurrenDate=#07/14/04# And TimeIn>#08:00:00pm#) OR
(CurrenDate=#07/15/04# And TimeIn<#04:00:00am#)
);

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244