Search results

Ok I found this =[LastName] & ", " & [FirstName] in my case it would be =[ShiftStart] & "," & [ShiftType] this would show 7:00 AM D Correct? but then how do I make it the value in the crosstab? Thanks,Tina

I would have to merge the fields to make this work wouldn't I? Since you can only have one value. I will research merge options. Thanks, Tina

Very cool this worked great. Another Question if I want to add another field like the type of shift. Example the query shows date 7:00 AM I have a field after the time in my table that has an s or sick or v for vacation d for day e for evening and n for night I want this to show up...

I have a table with employeeid employeename positionid then I have another table Positionid positionDescription How can I select the emplyee's name and have it file in the description of the position? so I select john doe from the drop down list and it enters the positiondescription...

Ok, a Form level look up field is best. I am glad to know because I was screaming trying to get table level look ups to work and I thought I was crazy. I can just store the value in the employeeid field because I have the relationship to show the name in the report or form later. Right...

Hi, I need some clarification about look up fields. is it better to do them at table level or Form level? If you do them at form level what is the advantage of remember the value for later use vs. store that value in this field Thanks, Tina

this is a table fields are name department position startdatetime enddatetime workcode the startdatetime looks like this 9/9/2009 15:05 I want the name as the row headers the date as the column headers the time as the junction between the two so that I can look and see that john doe...

This is a nursing database so the position is RN or A so that will not change. (A is nurses aide and RN is registered nurse) the Department will change if they are assigned to ER or OB or PT and they will change department sometime several times a day. for two hour shifts here and there...

So my next question is how do I account for the fact that the position does not change. the department changes but everytime I see this employee I want to show what their position is. so when I select that emplyee from a drop list I want a position field to populate with the posabbreviation...

I have a database for staffing. I have employee table with positions department table positions table schedule table I import the schedule from the time clock and I want to run reports from this. I have emplyeeid positionid departmentid scheduleid all primary keys in their table My...

I need a query that gives me .........date.....date.....date Name name name name This is like a crosstab query but I want a start time to show in the cross section of the table like this ............date.........date.........date Name...7:00 AM.....8:30 AM....7:00 AM name...8:00...

I actually figured something out on my own. I was beginning to wonder??? I will put it here incase anyone else needs it. this gives me 2 days from today. Since today is 8/28/2009 this gives only the data for 8/30/2009. Between Date()+2 And Date()+3 Thanks, Tina

Thank You again you are great. Tina

In my database today's date looks like this Between Date() And Date()+1 This shows me today with all of the scheduled times. How do I make it give me only tomorrow and only the next day I tried Between Date() And Date()+2 it gave me today and tomorrow. I want to seperate today and...

I need this format. Can it be done?? ................8/28/2009...8/29/2009...8/30/2009... John Doe.......7am.............9am..........7:30 AM Jane Doe.......10am...........3am..........8am I can use a crosstab query and I get the names and dates Can I make it show another field at the...

PERFECT! Can't Thank You enough. I will be sure and give you credit. thanks, Tina

I have date/time field 8/24/2009 7:00:00 AM 8/24/2009 11:00:00 AM 8/24/2009 7:30:00 AM 8/24/2009 3:00:00 AM 8/24/2009 5:00:00 AM 8/24/2009 8:00:00 PM 8/24/2009 7:30:00 PM 8/24/2009 11:00:00 PM 8/24/2009 7:00:00 PM 8/24/2009 3:00:00 PM I found the expression that gives me todays date...

That makes sense. That was the key I needed. If I only wanted part of the day say 1a to 4pm How would that look. Between Date() and time between 1:00:00 am and 4:00:00 pm Thank you so much. Tina

I have a field called shiftstart with the date and time. I put date() in criteria for this field thinking it would give me todays date information. I get nothing. What am I doing wrong please. Tina

BETWEEN DateAdd("h",-1,Date())+TimeSerial(0,0,0)) AND DateAdd("h",1,Date()+TimeSerial(0,0,0)) I just found the above code and the person who wrote it said, "That should return all records where the time stamp is between 11PM on the previous day and 1AM on the current day." Not what I need...