two queries in same table

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

Guest

I have one table that contains the dates of the month and the several
locations in each column... i would like to know if there is a way that i can
enter a search criteria for the date field as well as for the different
locations. for example i would like to be able to enter a day then turn
around and enter a location and pull up the information for that day of the
month for that location

thanks,
v
 
I have one table that contains the dates of the month and the several
locations in each column... i would like to know if there is a way that i can
enter a search criteria for the date field as well as for the different
locations. for example i would like to be able to enter a day then turn
around and enter a location and pull up the information for that day of the
month for that location

thanks,
v
Click to expand...

You can enter scores of criteria in a query. If you have a date field
and a location field, simply create a new Query based on your table,
and put a criterion such as

[Enter date:]

under the date field, and

[Enter location:]

under the location field. Am I misunderstanding? If so please post an
explanation of your table structure and perhaps an example of what
you'ld like to find.

John W. Vinson[MVP]
 
John Vinson wrote:
[snip]
You can enter scores of criteria in a query.
Click to expand...
[snip]


While it is true that two score warrants a plural,
the use of the plural might imply more than two,
which would be unacceptable ;-)
 
John Vinson wrote:
[snip]
You can enter scores of criteria in a query.
Click to expand...
[snip]


While it is true that two score warrants a plural,
the use of the plural might imply more than two,
which would be unacceptable ;-)
Click to expand...

Well... dozens then... <g>

What's the limit? 64 criteria?


John W. Vinson[MVP]
 
John said:
John Vinson wrote:
[snip]
You can enter scores of criteria in a query.
Click to expand...
[snip]


While it is true that two score warrants a plural,
the use of the plural might imply more than two,
which would be unacceptable ;-)
Click to expand...

Well... dozens then... <g>

What's the limit? 64 criteria?
Click to expand...

I guess it depends on what you consider a criteria to be ;-)

The limit on the number of entries in a Criteria row in the
QBE is 40 (two score ;-))

In SQL view, I was able to use up to 100 criteria combined
by AND. Actually, that could easily be expressed as scores
and scores, so I guess you were right all along ;-)

If you throw some ORs into the mix then you can get more,
maybe even a score of scores ;-)
 
Back
Top