Query using > and dates

[Guest]

When I run my query, I get nothing. I know I should at least be getting one
record, as there is currently only one record that contains this information.

 

[Chaim]

What's the date of this one record?

--

Chaim

When I run my query, I get nothing. I know I should at least be getting one
record, as there is currently only one record that contains this

information.

 

[Guest]

The date of the record is August 17, 2005. However, I think I may have
discovered the problem. I have two columns within my table that I want to
pull data from and if I put the formula in only one column of the query it
works. But, when I put the information in the second column, it doesn't
work. Currently, I have two different queries - I would like to only have
one query.

 

[Chaim]

What are the queries that you have currently?

Could you show us the SQL? If you're creating the queries in the query
builder, right click in the window and select 'SQL View', then copy and
paste the SQL from the two queries in a response.

 

[Guest]

Chaim:

I was able to get it to final work. All I had to do was drop down a row for
the second column and it worked.

Thanks for your help anyway.

 

[Chaim]

I didn't follow that. Can you explain what you mean by 'drop down a row for
the second column'?

 

[Amy Blankenship]

I think he/she meant or instead of and in the criteria...

HTH;

Amy