Query using > and dates

E

emanw

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.
 
C

Chaim

What's the date of this one record?

--

Chaim


emanw said:
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
Click to expand...
information.
 
E

emanw

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.
 
C

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.
 
E

emanw

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.
 
C

Chaim

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