By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,662 Members | 1,790 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,662 IT Pros & Developers. It's quick & easy.

Automating queries by using a reference date.

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
-----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:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBP+Jq1IechKqOuFEgEQIX4ACgpc6zKie9f6As/Kt1yPqZdn4T5ZgAoKqz
RedpkYEylXgJki5EHgQ6mX+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


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.