Recent content by valsanch

Additional info: My field "TotalContactHours" isn't from a table. I actually created this field by subtracting FinishTime from StartTime. Not sure if this is creating a problem...

Hello, I ended up focusing on another part of the database and now I am back to this query. Sorry for the constant questioning, probably due to my new entry into the Access World. I went back and got rid of the fidl name "Date" and changed it to "SimDate". Here is my code: SELECT...

Hi PBaldy and Galaxiom, I found the problem. I have no idea why, but I had to put 2 instead of 1 in the column() function. Now all of the fidelities are auto populating and are correlating with the simulator type. I find this odd though because my row source only has 2 fields selected and I...

One step closer! So, the error is no longer there but now the field is populating the field with the simulatortype and not the corresponding fidelity. So for example when I choose "TraumaMan" from my Simulator list. The Fidelity field will populate with "TraumaMan" and not the fidelity of the...

I read a link on auto-population in a form. I thought I followed it to a "t" but my field is not being auto-populated. I have several tables, however, just two specific to what I am trying to do. I feel so close to a solution. I have a table called, "tblActivity" and "tblSimulators". I created a...

Hi PBaldy, I went ahead and read your link on auto-population in a form. I thought I followed it to a "t" but my field is not being auto-populated. I have several tables, however, just two specific to what I am trying to do. I feel so close to a solution. I have a table called...

Hi CJ_London, correct, but if I take them off, and try to run the query, I get an error message reading, "The expression you entered contains invalid syntax, or you need to enclose your text data in quotes."

Brian, Thank you so much for your advice. I really want to be as clean as possible as I learn access and put it into practice. I went back and took the spaces out of my field headings. The reason I have date and time separated is because I am tracking date, start time and finish time. This...

I ended up adding the month function to the same datediff query. I then did a new query summing the hours by month. I get the right numbers. Is it not productive to have done the datediff, month and sum functions in two separate queries?

Thanks! Unfortunately, I'm not doing the sum function correctly. When I add, Month(Date) to the third column of the query, it will return the correct corresponding number. However, when I add the sum(contact hours) it says I need quotes around everything so when I add the quotes and run the...

Hello All, I am VERY, and I mean VERY new to Access. I've been racking my brain all afternoon and googling like crazy. I just completed two levels of training on Access 2010 and have never worked with the program before. I already set up my tables and now I am on to querying. I have a...