10-15-2004, 12:31 PM
I am trying to write a query in Access that is tied to a couple of combo boxes. The table has a 13 fields (File date, Jan, Feb, etc.) One of the combo boxes is tied to field data (dates), while the other is tied to field names (months). I want my query to pull a certain month's data based on the month and date selected. I know I probably need to create a variable for the month name and then reference this in my query, but I cannot get it to work. Any tips?