Search results

i have a form with a list box call it list1 populated by a query with a field loc# with a dbl click event that opens aother form with another list box (list2)that i want to use the loc# from previous list box(list1) along with the query for current list box(list2) to populate list2 list1 query...

hey brian, ran into a little dilema when i come on shift at 2000hrs i have to go in and change my query then at midnight change it back is there a way to put a if statement or something in the query so for instance if the date was before midnight run the query one way and if after run another...

hey brian thanks alot i cant believe it was so easy i played with the +- notation but never thought of using multiple criteria stupid me

yes i did and i modified as follows date()-2 changed to -1 for yesterday and date()-1 to date() to reflect today is that correct

its going to be run each morning so it should be fine i changed to date()-1 and date() but its not returning records for today

the logic behind that was i needed to have an incident # with format ddmmyy+1 that auto incremented for that day and reset on a new day ie 1808041,1808042 input via form i have that post on here as well net

hey brian as you see my original posts was after midnight so it was yesterday and today and my last was befor midnight so today and tomorrow anyway its like this i start my shift at 2000hrs and end the next morning at 0600hrs so that is my query i need to query from 2000hrs on one day until...

thanks for the reply wayne which example above and are you saying i shouldn't use date as a field in my table. here is my table and query

hey brian thanks for the help i tried it but its returning records for today only let me give you a better picture I have a daily log sheet fields are date disp arriv clrd typeofcall location my shift hours overlap so i need to query my log to show records from 2000hrs today til 0600hrs...

I have a report based on a query that needs to look for records between 2000hrs on one day and 0600hrs the next but i cant seem to figure it out any help would be appreciated.

Wayne, Everything Works Fine Except Its Dropping The First 0 In 0808041 So It Reads 808041

where do i put the code ? i got it never mind thanks for your help

ok got it working except for the format where do i put the string :o WHAT I REALLY WANT TO DO IS TAKE THE IncidentDate format ddmmyy and the IncidentNumber combine them put the in the field Incident for example and use that number for the primary key. and i wanna say thanks a lot for your help

Is There A Way To Combine It Into One # Like 07080401,07080402 Etc

i need to make an incident # to be stored in a table in the format ddmmyy and then starting at 1 for the first incident on the day auto increment and reset back to one on a new day. any help would be appreciated

Could use some help too hey harry is it possible to get a sample also netuse@debouck.com

hi all im a newbie and i have a form with a text field for a time is there a way to click the field and have the current time insert automatically.