Recent content by felicia.scott@

Hi, I'm using a field inside of my query to give me a calculation then taking that calculation to get a separate #. When I run, it asks for the name of the calculated field. Is there something I should do differently or should I have the calculation happen in a separate query? Example...

Arnelgp, Are you telling me to add a field SmallTeamID to all of the tables?

Thankyou to you both. I will make the corrections to the database and will try the suggestions for the form and combo box.

I am wanting to do 2 things with my database (in the field control, I have no SQL exp)... 1. I want to create a pull down menu that allows the name of the small team employee to be selected that opens to a form that allows comments to be created for that same person for the Month YY I choose...

Found the answer... thank you. Thank you. THANK YOU... for anyone else, here is the non-SQL how to...

I found a couple that could work but the error says they are from an earlier version of Access and doesn't allow me to open. The help suggest compacting them but again, I can't get them open to compact. I see the question has been posed ad nausem but I am still stuck.

Greetings, I am a novice query builder and seek formula assistance to calculate the difference between two dates while also excluding weekend dates from the calculation. I found a helpful MasterDates database here that provides the weekend dates to exclude however, I do not know how to...