SQL query

[Guest]

I would like to show issues open for today and i have the folowing sql that
is not working:

SELECT [Remedy Tickets].[Ticket #], [Remedy Tickets].[Ticket Description],
[Remedy Tickets].[Assigned To], [Remedy Tickets].[Open Date], [Remedy
Tickets].Status, [Remedy Tickets].[#Groups], [Remedy Tickets].[Client
Impact], [Remedy Tickets].[Time Closed], [Remedy Tickets].[Time Diference]
FROM [Remedy Tickets]
where [Remedy Tickets].[Open Date] = Now()
ORDER BY [Remedy Tickets].[Ticket #] DESC;

How do I change this code so it will show me all issues open for today?
Also I would like to have another query that will show issues open for today
and previous day. Thanks

 

[Scott]

instead of using Now() try Date(), Now() includes time with the date.

 

[John Spencer]

SELECT [Remedy Tickets].[Ticket #]
, [Remedy Tickets].[Ticket Description]
, [Remedy Tickets].[Assigned To]
, [Remedy Tickets].[Open Date]
, [Remedy Tickets].Status
, [Remedy Tickets].[#Groups]
, [Remedy Tickets].[Client Impact]
, [Remedy Tickets].[Time Closed]
, [Remedy Tickets].[Time Diference]
FROM [Remedy Tickets]

WHERE [Remedy Tickets].[Open Date] = Date()

ORDER BY [Remedy Tickets].[Ticket #] DESC;

OR if Open Date has a time attached to it you might need
WHERE [Remedy Tickets].[Open Date] >= Date()
and [Open Date] < DateAdd("d",1,Date())

For today and yesterday try

WHERE [Remedy Tickets].[Open Date] >= DateAdd("d",-1,Date())
and [Open Date] < DateAdd("d",1,Date())




'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[Guest]

Thank you very much

SELECT [Remedy Tickets].[Ticket #]
, [Remedy Tickets].[Ticket Description]
, [Remedy Tickets].[Assigned To]
, [Remedy Tickets].[Open Date]
, [Remedy Tickets].Status
, [Remedy Tickets].[#Groups]
, [Remedy Tickets].[Client Impact]
, [Remedy Tickets].[Time Closed]
, [Remedy Tickets].[Time Diference]
FROM [Remedy Tickets]

WHERE [Remedy Tickets].[Open Date] = Date()

ORDER BY [Remedy Tickets].[Ticket #] DESC;

OR if Open Date has a time attached to it you might need
WHERE [Remedy Tickets].[Open Date] >= Date()
and [Open Date] < DateAdd("d",1,Date())

For today and yesterday try

WHERE [Remedy Tickets].[Open Date] >= DateAdd("d",-1,Date())
and [Open Date] < DateAdd("d",1,Date())




'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

I would like to show issues open for today and i have the folowing sql that
is not working:

SELECT [Remedy Tickets].[Ticket #], [Remedy Tickets].[Ticket Description],
[Remedy Tickets].[Assigned To], [Remedy Tickets].[Open Date], [Remedy
Tickets].Status, [Remedy Tickets].[#Groups], [Remedy Tickets].[Client
Impact], [Remedy Tickets].[Time Closed], [Remedy Tickets].[Time Diference]
FROM [Remedy Tickets]
where [Remedy Tickets].[Open Date] = Now()
ORDER BY [Remedy Tickets].[Ticket #] DESC;

How do I change this code so it will show me all issues open for today?
Also I would like to have another query that will show issues open for today
and previous day. Thanks