Automating queries by using a reference date.

[EnriqueM]

One question: I created an access database that has been extremely
useful in my work. I dont' even know at what level of knowledge I am
at. I read a lot about how to create a database, created many tables,
connected them and then created different kinds of queries. (One thing
I have never done is reports, because I really don't need them)

I have many queries to track a particular job or aspect of it. i.e. I
sent on a particular item on a certain (SentDate). Now I need a
formula or something to produce a query of jobs that were sent, say 7
business days (mon tue wed thur & Frid only) from the "SentDate"

I should say, I use the DESIGN VIEW to do my queries. And on the
"SendDate" field, I could query for ">12/6/2003" and I will get all
jobs later than this date. But that is as much as I know.

There must be a way to "automate" queries, as I explained in the
aforementioned paragraph. (repeated below).

*** Now I need a formula or something to produce a query of jobs that
were sent, say 7 business days (mon tue wed thur & Frid only) from the
"SentDate" ***

I also would like to learn more on automating quieries in general.

I use Access 2000 (9.0.3821 SR-1)

TIA

Enrique

[MGFoster]

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

It's easier to get the past 7 days than it is to get the past 7
business days (Mon - Fri). E.g.:

In the SentDate criteria put:

Between Date()-7 And Date()

This will get the records that have a SentDate between 7 days ago and
today's date.

HTH,

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

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

iQA/AwUBP+Jq1IechKq OuFEgEQIX4ACgpc 6zKie9f6As/Kt1yPqZdn4T5ZgA oKqz
RedpkYEylXgJki5 EHgQ6mX+0
=4fxu
-----END PGP SIGNATURE-----

EnriqueM wrote:

One question: I created an access database that has been extremely
useful in my work. I dont' even know at what level of knowledge I am
at. I read a lot about how to create a database, created many tables,
connected them and then created different kinds of queries. (One thing
I have never done is reports, because I really don't need them)

I have many queries to track a particular job or aspect of it. i.e. I
sent on a particular item on a certain (SentDate). Now I need a
formula or something to produce a query of jobs that were sent, say 7
business days (mon tue wed thur & Frid only) from the "SentDate"

I should say, I use the DESIGN VIEW to do my queries. And on the
"SendDate" field, I could query for ">12/6/2003" and I will get all
jobs later than this date. But that is as much as I know.

There must be a way to "automate" queries, as I explained in the
aforementioned paragraph. (repeated below).

*** Now I need a formula or something to produce a query of jobs that
were sent, say 7 business days (mon tue wed thur & Frid only) from the
"SentDate" ***

I also would like to learn more on automating quieries in general.

I use Access 2000 (9.0.3821 SR-1)

TIA

Enrique