Good morning all,
I have a make-table query and am using the expression builder to set the criteria. I want it to look at the values entered in another table to determine what gets put into the new table. What I have is:
Between [DateTable].[StartDate] And [DateTable]![EndDate]
But it keeps asking me to enter "[DateTable].[StartDate]" and "[DateTable]![EndDate]". How can I make it go to the table to get this information?
There is only one record and will only ever be one record in the table and those are the only two fields. I have it storing the information in a table, because several different things are using these two dates and it is quicker and easier for the user to just have to enter it once and it store it in a table rather than entering the same information on several screens.
Thanks for the help!
The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!