SQL query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
'====================================================
 
Thank you very much

John Spencer said:
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
Click to expand...
Click to expand...
 
Back
Top