 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / July 2006Problem with Query
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 >I have a query made up of several different queries. The results are a >count [quoted text clipped - 5 lines] > multiple > records? Any suggestions on how to get results between dates? Thanks! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.