A
Alana
Hi, I'm new to Access 2003 and am trying to figure out the difference between
queries and reports. I have a database which includes companies, licensing
agreements, and products. So many companies can have multiple agreements on
the same product, and a company can have agreements on multiple products. I
think I've finally got my relationships set up properly and everything seems
to be cascade-updating and everything. Now I need to figure out how to USE
my database! Agreements have expiration dates, and I need a way to generate
a list every month of agreements which will expire in the next 30 days, and
it would be nice if this list had the company contact information because I
have to send them a letter to tell them their agreement is going to expire.
So my question is - what is the most efficient way to accomplish this?
Should I create a query to look up all agreements with expiration dates
between, say, 3/1/2005 and 3/31/2005? Or would a report be a better
solution? Ideally, I would get the information into such a format (maybe
Excel) so that I could easily do a mail merge into a Word document with the
company name/address and the name of the product and type of agreement that
is expiring. I have been told that if I learn some visual basic I can make
this into something as simple as a button that generates the list and exports
it, but for now I'm more concerned with just getting the information into a
usable format (I'm more familiar with Excel, which is why I chose that). If
someone can direct me to whether a query or a report would be the best
option, I would appreciate it. I will probably use Access help to figure out
how to actually do it. Any remarks on the wizards for queries/reports in
Access? I tried to use the wizards to set up my tables originally, but ended
up deciding that Design view made more sense to me. Thanks!
queries and reports. I have a database which includes companies, licensing
agreements, and products. So many companies can have multiple agreements on
the same product, and a company can have agreements on multiple products. I
think I've finally got my relationships set up properly and everything seems
to be cascade-updating and everything. Now I need to figure out how to USE
my database! Agreements have expiration dates, and I need a way to generate
a list every month of agreements which will expire in the next 30 days, and
it would be nice if this list had the company contact information because I
have to send them a letter to tell them their agreement is going to expire.
So my question is - what is the most efficient way to accomplish this?
Should I create a query to look up all agreements with expiration dates
between, say, 3/1/2005 and 3/31/2005? Or would a report be a better
solution? Ideally, I would get the information into such a format (maybe
Excel) so that I could easily do a mail merge into a Word document with the
company name/address and the name of the product and type of agreement that
is expiring. I have been told that if I learn some visual basic I can make
this into something as simple as a button that generates the list and exports
it, but for now I'm more concerned with just getting the information into a
usable format (I'm more familiar with Excel, which is why I chose that). If
someone can direct me to whether a query or a report would be the best
option, I would appreciate it. I will probably use Access help to figure out
how to actually do it. Any remarks on the wizards for queries/reports in
Access? I tried to use the wizards to set up my tables originally, but ended
up deciding that Design view made more sense to me. Thanks!