Learned people I have a Parameter Union Query as follows:
SELECT Seeds.[Veg or Plant Type], Seeds.Variety, Seeds.[Harvest Start 1]
FROM Seeds
WHERE (((Seeds.[Harvest Start 1]) Between [Enter start Date:] And [Enter End Date:]));
UNION
SELECT Seeds.[Veg or Plant Type], Seeds.Variety, Seeds.[Harvest Start 2]
FROM Seeds
WHERE (((Seeds.[Harvest Start 2]) Between [Enter start Date:] And [Enter End Date:]));
UNION
SELECT Seeds.[Veg or Plant Type], Seeds.Variety, Seeds.[Harvest Start 3]
FROM Seeds
WHERE (((Seeds.[Harvest Start 3]) Between [Enter start Date:] And [Enter End Date:]));
UNION
SELECT Seeds.[Veg or Plant Type], Seeds.Variety, Seeds.[Harvest Start 4]
FROM Seeds
WHERE (((Seeds.[Harvest Start 4]) Between [Enter start Date:] And [Enter End Date:]));
When I run the query (and 2 other similar ones) it asks me for the start Date and End Date twice; what am I doing wrong folks?
I would have expected it to ask me once or 4 times