Hello,
I have a very limited knowledge of Access and am struggling through and enjoying creating my first database. When in query design view, I created a field by entering the following formula into the field region:
Lab$: [LabHours]*([CrewRate]+[OHRate])
So when I switch to datasheet view, I get a new column that executes exactly what I want it to do.
Question - can I in turn use Lab$ in the same query in which it was created? I am able to see it and use it when I create query 2 by using query 1 but I can't figure out a way to use it in the query 1.
Thank you,
Rob Schmidt
I have a very limited knowledge of Access and am struggling through and enjoying creating my first database. When in query design view, I created a field by entering the following formula into the field region:
Lab$: [LabHours]*([CrewRate]+[OHRate])
So when I switch to datasheet view, I get a new column that executes exactly what I want it to do.
Question - can I in turn use Lab$ in the same query in which it was created? I am able to see it and use it when I create query 2 by using query 1 but I can't figure out a way to use it in the query 1.
Thank you,
Rob Schmidt