Auto Enter Field Value From Table Into Query Criteria

[dnelson24]

I have a database that has numerous MakeTable queries all defined to run Between date ranges. What I want to be able to do is modify a table StartDate and a EndDate and have each one of my queries get this StartDate and EndDate from the 2 fields in this table! Can this be done? How do I call a field value from this table when using the Between Date function in criteria? Between [TableX]![StartDate] And [TableX]![EndDate].....????

Thanks in advance!

 

[mikey69]

Don't know that you can do it directly from table fields, but you could read the table into fields in a form and then use them in a parameter query.