|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 18th, 2007, 05:16 AM
posted to microsoft.public.access.reports
|
|||
|
|||
SQL query
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 
|
|
#2
August 18th, 2007, 12:54 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
SQL query
instead of using Now() try Date(), Now() includes time with the date.
"Greg" wrote in message ... 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
|
|
#3
August 18th, 2007, 02:45 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
SQL query
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 '================================================= === Greg wrote: 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
|
|
#4
August 18th, 2007, 11:38 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
SQL query
Thank you very much
"John Spencer" wrote: 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 '================================================= === Greg wrote: 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
