Recent content by redclaygirl

thank you. no worries.

I am trying to group time entries so that I can say, between 8AM and 10AM there were this number of calls. I have a field called Time_Assigned with numberous time entries (such as 08:15:33 AM) corresponding to another field called Incident_Type (such as medical). The data spans a whole year so...

Thank you so much for your help. However, I am in the beginning stages with Access and not sure about the tblcode stuff. Are you saying that I start with an update query and then plug in the tblCode SET tblCode.Code_B = tblCode.Code_A, tblCode .Code_A= Null; part in my Code_B field criteria...

Thank you so much! It works perfectly.

Actually, I have no idea how to use the VBA in Excel. Any more ideas? It seems like there should be some other way to convert my original date to weekdays so that I can use them as categories. Any help is welcome.

I will give it a try. Thank you.

I used the format text box in my query design to generate weekdays as text from my date field. It works great. However, I was hoping to produce some graphs where I could use those weekdays as 7 categories to plot against some other data. Now I am finding that to be a problem as the "real"...

I am trying to extract data from one field and then put it into another field. I have 2 fields, Code_A and Code_B. I am trying to take the Code * data from Code_A and put it in Code_B. Any help is appreciated. Code_A Code_B Alpha Code 3 Code 3 Alpha Code 3 Code 2 Delta Code 3 Code 3...