Help!!! Having Problems w/ Criteria

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

Guest

I am working on a project and I am doing a quey. Pert of the criteria there
is actually 3 I am having to put in. Everything is working until I get to
having to put in a greater than criteria. Two of my columns are labeled
RequiredDate and ShippedDate. In the criteria I am trying to to
RequiredDate and it will not work. I should get 12 records back but its
Click to expand...
giving me a error message. If I type in the ShippedDate Criteria
ShippedDate>RequiredDate it will run but not correctly it doesnt give me the
info I need. I really need help.

Thanks
 
Can you give us more information about the table structure? And post the SQL
statement of the query that you're trying to use.
 
I am actually not very familiar w/ access. I'm taking a class onit and I am
stumped trying to do this. Everything else works but this. My table
consists of information from 3 tables. Customers, Orders, Shippers.
My field names are Company Name(Customers Table) , Country(Customers Table),
RequiredDate(Orders Table), ShippedDate(Orders Table), CompanyName(Shippers
Table). Under the Country criteria I have Not USA, Under the Company
Name(Shippers) I have Like United*, The ShippedDate is where I'm trying to
put >RequiredDate and it will not work. This is all I'm typing. I hope this
is what you need to help me.
 
Ed,
Thanks so much it worked Great!!!!


Edward G said:
In the ShippedDate criteria enter >[RequiredDate].

Ed


Stacie said:
I am working on a project and I am doing a quey. Pert of the criteria there
is actually 3 I am having to put in. Everything is working until I get to
having to put in a greater than criteria. Two of my columns are labeled
RequiredDate and ShippedDate. In the criteria I am trying to to
giving me a error message. If I type in the ShippedDate Criteria
ShippedDate>RequiredDate it will run but not correctly it doesnt give me the
info I need. I really need help.

Thanks
Click to expand...
Click to expand...
 
Stacie,

Glad to hear it. I think though I should have explained WHY it works. When
you are referring to another field
in your query it has to be enclosed in brackets.

Ed


Stacie said:
Ed,
Thanks so much it worked Great!!!!


Edward G said:
In the ShippedDate criteria enter >[RequiredDate].

Ed


Stacie said:
I am working on a project and I am doing a quey. Pert of the criteria there
is actually 3 I am having to put in. Everything is working until I get to
having to put in a greater than criteria. Two of my columns are labeled
RequiredDate and ShippedDate. In the criteria I am trying to to
RequiredDate and it will not work. I should get 12 records back but its
giving me a error message. If I type in the ShippedDate Criteria
ShippedDate>RequiredDate it will run but not correctly it doesnt give
Click to expand...
me
the
info I need. I really need help.

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top