Query

[petewitty]

Hi I have a table with 35 fields in it, when running the query i put in just two fields I.e 1 and 35 one week nad the next week it could be 16 and 17, this ok if you write a new query every week, I am now trying to make a macro so this could be run automatlly just adding the winning numbers, but i cant see a way of making the query ask me the field name, if you understand what i'm saying please help
regards
Pete

 

[fneily]

Check out:

How to implement Query by Form (QBF) with dynamic QueryDef

http://support.microsoft.com/kb/q210242/