SubReport Created from query which is LIKE all User names on report

[raytackettsells]

I have a report created from query 1 - in this query I am pulling to pieces of information for the report.

Between [Reports]![Query1]![Text21] And [Reports]![Query1]![Text20]



I also need the query for the subreport which is QUERY2 to pull only the users from QUERY1 report I am a novice but tried:

Between Reports!query1!username AND reports!query1!username

Any idea on how I can use the between paramaters for the date (text21/text20) and also have the subreport look at query1 report showing only information for the usernames displayed? As always the help on here is extremely prompt and great! Thanks in advance for the assistance or guidance to where to find it!

Raymond

[June7]

BETWEEN AND won't work.

Try something like:

SELECT * FROM sometable WHERE userID IN Query1

[raytackettsells]

BETWEEN AND won't work.

Try something like:

SELECT * FROM sometable WHERE userID IN Query1

complete amateur so i will attempt to go research how select queries work. thanks