Oct 19 2010, 11:17 AM
I am sure this is posted somewhere else, but I cannot seem to find it with the Time aspect attached.
I have 3 fields in my query.
fld Date and Time is just Date and Time joined together.
Is there a way to write the Between function in the criteria field in the fldDateandTime field to be
"Between [startdate] #7:00AM# and [enddate] #7:00AM#"
as to return all the records for lets say the 18th at 7am to the 19th at 7am
I apologize in advance if this is basic.
Oct 19 2010, 11:22 AM
Between ([startdate] + #7:00AM#) and ([enddate] + #7:00AM#)
Make sure that startdate and enddate are declared in the query parameters as datetime values.
Oct 19 2010, 12:41 PM
I want the [StartDate] and [EndDate] to be values entered by the person running the query so they are not actually fields in any table. I get an error when I enter that line in the criteria.
Here is the Sql for the query..
SELECT OnsiteGuestCount.OnSiteID, OnsiteGuestCount.CountDate, OnsiteGuestCount.CountTime, [OnSiteGuestCount].[CountDate] & ", " & [OnSiteGuestCount].[CountTime] AS DateandTime, OnsiteGuestCount.Poker, OnsiteGuestCount.BJ, OnsiteGuestCount.Slots, qry_Max_Times.MaxOfBJ, qry_Max_Times.theBJTime, qry_Max_Times.MaxOfPoker, qry_Max_Times.thePokerTime, qry_Max_Times.MaxOfSlots, qry_Max_Times.theSlotsTime, [MaxofSlots] & ", " & [theslotstime] AS HighCountSlots, [MaxofPoker] & ", " & [thePokertime] AS HighCountPoker, [MaxofBJ] & ", " & [theBJtime] AS HighCountBJ
FROM OnsiteGuestCount INNER JOIN qry_Max_Times ON OnsiteGuestCount.CountDate = qry_Max_Times.CountDate
WHERE ((([OnSiteGuestCount].[CountDate] & ", " & [OnSiteGuestCount].[CountTime]) Between ([startdate]+#12/30/1899 7:00:00#) And ([enddate]+#12/30/1899 7:00:00#)));
Oct 19 2010, 12:45 PM
Bah.. I didnt read your post correctly.. Hahahaa I added the parameters and it works like a charm! thats what I get for being impatient.