How do I enter a criteria in access that will give me a query wit.

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

Guest

How do I get criteria expressions for my Access 2000.
My homework is about getting a query that will list only stores with leasing
ending in 2003, but I don't know the criteria expression for that.

I'll be grateful if someone can help.
Thanks
 
Humble said:
How do I get criteria expressions for my Access 2000.
My homework is about getting a query that will list only stores with leasing
ending in 2003, but I don't know the criteria expression for that.

I'll be grateful if someone can help.
Thanks
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

In the Query QBE grid, in the column for the lease end date, in the
Criteria row, put this:

Between #1/1/2003# and #12/31/2003#

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQjfrLYechKqOuFEgEQKpCQCgjMBqIGsNPM3He7ExBUo3eCr8YRMAni5g
FkFoQDR5EyD1G8UYvpEhnLsV
=ec7b
-----END PGP SIGNATURE-----
 
How do I get criteria expressions for my Access 2000.
Click to expand...

"get" them??? You don't "get" them, you write them.
My homework is about getting a query that will list only stores with leasing
ending in 2003, but I don't know the criteria expression for that.
Click to expand...

If you could explain what field in the table contains the information
which would let you determine that, someone might be able to help. Do
you have a Date/Time LeaseEnds field in the table? If so a criterion
of

BETWEEN #1/1/2003# AND #12/31/2003#

would work. If not, please explain what exists in the table which
would allow you to choose a record.

John W. Vinson[MVP]
 
Back
Top