How to Use Field Twice in Query

[foofoo]

Hello -

I am a brand new Access user & want to set up a query using a field
twice in the query. I want the query results to look like this:

Date=08/02/10 Date-08/09/10 Average Volume for Both Dates

Is there a simple way I can do this without using a macro? I tried
adding the Date field to the query twice, using this criteria for the
first entry - =#8/2/2010# - and this criteria for the second entry -
=#8/9/2010#. When i run the query, however, I get no results. What
am I doing wrong?




Thanks

 

[David W. Fenton]

m:

I am a brand new Access user & want to set up a query using a
field twice in the query. I want the query results to look like
this:

Date=08/02/10 Date-08/09/10 Average Volume for Both Dates

Is there a simple way I can do this without using a macro? I
tried adding the Date field to the query twice, using this
criteria for the first entry - =#8/2/2010# - and this criteria for
the second entry -
=#8/9/2010#. When i run the query, however, I get no results.
What
am I doing wrong?

I'm very unclear on what your question is.

Do you mean that you want to return records where a particular date
field matches one of two values, #8/2/2010# or #8/9/2010#?

If so, in the QBE, you should be able to type "#8/2/2010# Or
#8/9/2010#" into the criteria row under your field and it should
work just fine.

If that's not what you mean, you're going to have to reword it. And
it would be good if you don't use "Date" for anything, since that
just confuses things (it's a function that returns the current date,
but it's also a generic term that makes it more difficult to
understand what you're asking).