Hi all,
its been a while since i have posted. I hope y'all doin fine.
I have a query which can be constrained two different ways. it can be constrained by the join, or it can be constrained by criteria. i was wondering which one hapens first and which one is prefered.
here are the details. i query a table which has three to five years worth of data. the user enters the desired dates on a form (usually of the past year). my query needs to reference another query which already has criteria of the same dates. so my question is, do i gain by entering again the creteria in this new query, or is it enough that i am joining it to the other query.
thanks,
sam
its been a while since i have posted. I hope y'all doin fine.
I have a query which can be constrained two different ways. it can be constrained by the join, or it can be constrained by criteria. i was wondering which one hapens first and which one is prefered.
here are the details. i query a table which has three to five years worth of data. the user enters the desired dates on a form (usually of the past year). my query needs to reference another query which already has criteria of the same dates. so my question is, do i gain by entering again the creteria in this new query, or is it enough that i am joining it to the other query.
thanks,
sam