Search results

I want a query to return current date with starttime stamp between 1am and 4pm Then I plan to create another query that will return current date with starttime stamp between 2pm and 10pm I have departments that have day and and night shift so I have shiftstart date/time and shiftend...

I'm kinda new. I will research the Mid() function. Thanks, Tina

I have this number in my table in a field abcd/6300/6300123/630012379999 I want this field1...field2....field3 123.......7........9999 I only want the last 8 numbers seperated out. Thank You for your help. Tina

I have a file import from Excel. It is a staffing spread sheet. It is all spread out. example .........Column a .....Column b Column c Column d Row 1 person name Row 2 ....................date Row 3 .................................Dept Row 4...

I have a switch that produces a .txt file that I import into Access. this file gives me military time like 1542 and 723 I would like to change this to 7:23 AM and 3:42 PM is this possible? Also I get minutes in this format 00053 00114 I would like this to be :53 1:14 Any help would be...

Sorry I am new. Do I put this in the criteria of an update query. What I have been doing is changing to the SQL view of an update query and adding there. That did not work so where do I put this? Dateserial(Right(string,2),mid(string,3,2), left(string,2)) Thanks.

Cannot find the answer after much reading. I am not sure how to apply the answers I have found. Thank You in advance. I have a switch that produces a .txt file that I import into Access. Access imports the date as a text field mmddyy. If I try to change it to number or date on import it...