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