Search results

ya I tried that Field: Field3 Table: phonedata update To:CDate([Field3]) It didn't work. This looks good where do I put it DateSerial(Mid([Field3],5),Mid([Field3],1,2),Mid([Field3],3,2)) I tried this (it did not work) Field: Field3 Table: phonedata update...

I want to take a string 070809 for example and convert it to a date. table name: phonedata field with string is Field3 I have tried so many ways I have forgotten what I tried. I cannot get it right. should I create an update query? Field: Field3 Table: phonedata update...

So much great information here. The problem I have is I have implemented several solutions that I have found on this forum. I still struggle when I find code or figure out code because I cannot figure out.... WHERE DO I PUT THIS!!! does it go in query field does it go in query SQL view...

What I mean by add a field is a field that when I group by it will show all my names side by side not each in its own row. Thanks,Tina

I have attached two pictures with notes. Please review and tell me what I need to change to make this work. I am so close just not sure if I should add a field or what. Also not sure what makes it put some items on its own row and some items are side by side. Thank You, For any help, Tina

So I found what you are talking about. I changed the condition 1 to Expression is Then I get lost This is my row ID, full_name, Dept, Position, location When the location field contains "ws" I want ID, full_name, Dept, Position, location to all be pink so would I write Expression is

I do not understand what you are saying. Would the above go in a query? I have only used the condition button and it looks like it only works on one field. Thank You, Tina

Sorry, It timed out and must have removed the attachments. They should be there now. Tina

I have a bit of code I have tried to modify to give me what I want but I need help with last little bit. See Attached query I want the RN and A as the rows and I want the departments as the columns. I have a problem with the rows because it only shows me one RN and one A their should be 6...

Thank You, I will read into this. I also checked out your link looks like some really good clear data. Thanks, Tina

I feel confident about my foundations with tables I just need the VB and expressions training. I have been thrown in the fire and I have two large databases I am working on and trying to learn SQL and SharePoint all at the same time. I have beginner training for all of this and I have...

OK, I have discovered this TRANSFORM First(Format([StartDateTime],"HH:MM") & " " & [shifttype]) AS ValFld SELECT YourTable.Name FROM YourTable GROUP BY YourTable.Name PIVOT Format(Int([StartDateTime]),"dd/mm/yy"); after I tweaked it, it worked perfectly. I need some training. This...

Thank You so much. This is perfect. Tina

I have added the ShiftType as a row like suggested. I have attached two views showing what I have. I just need it to show me what type of shift each time is. It shows me the start times but each start time could be start of vacation, sick, funeral, or training. How do I make it show...

I agree but I need some examples of how to use some of these features.

I have been researching some advanced training. The products tab on this site has some tutorials that look good for Access 2007. Has anyone taken it or other advanced training classes that they would recommend? Thanks, Tina

I am sorry. My reply was uncalled for. I do not understand pivot tables, but I'm trying and obviously getting frustrated in the process. Apparently I don't communicate very well either since you all thought I wasn't trying. I will study some more and see what I can find. Again I...

I didn't just past code you big jerk. I have studied and worked on this and broke it twice trying different things. I have added columns and rows and merges and nothing has given me what I want. If you are going to be rude you can go play some where else. I realize it is frustrating to deal...

I need to make a field look different based on a condition. What I have done is I have a default value field that puts a U for updated in a certain field so I import the data from excel then when people add new data my U gets put in the field. I think I need a macro that checks the field...

I was given this code that worked great but I need to tweak it. TRANSFORM First(Format([StartDateTime],"HH:MM")) AS ValFld SELECT YourTable.Name FROM YourTable GROUP BY YourTable.Name PIVOT Format(Int([StartDateTime]),"dd-mm-yy"); row is name column is date and value is starttime I need to...