Problem with Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query made up of several different queries. The results are a count
so the data displayed is only one record. I would like to be able to add a
"date of visit" field to my query and specify the time period I would like
the data for. When I add this field to my query and try to run it it displays
a message "query to complex". Is this because it is trying to show multiple
records? Any suggestions on how to get results between dates? Thanks!
 
Jamie

Is there a field in the underlying data that you could use to select the
date or time period?

Is this one field or two?

If you add a new field to your query that contains (or calculates) the
time-of-day, you could use a criterion expression with "Between xxxx And
yyyy".

Regards

Jeff Boyce
Microsoft Office/Access MPV
 
Back
Top