Need Urgent report (HELP!!)

[Kenny Silva]

Dear friends:

I just installed Acces 2000 in my computer and I need to do a report
urgently. I bought Acces for Dummies, but I still dont get it...

I have two tables (2004 & 2005) and I need to print a list of
customers that used us on 2004 and have not use us yet on 2005. I
tried creating a query and I Learned how to program reading my book.
However I cannot find a statement that could Help me... CAN YOU????

PLease, help!


Thank you in advance.

Kenny Silva

 

[Scott McDaniel]

How do you determine whether a customer "used" you in 2004? Do you have a
table that holds a "DateOfLastUse", for example? Or perhaps an invoice
table, Contacts table, etc etc ... how you do this determine how your data
is stored. In general, you'd build a query by (a) opening a new query (from
the database window, select Queries - New) and (b) selecting the appropriate
table(s) and (c) selecting the fields you want displayed in your report.
When you determine which date field you'll use to decide whether a customer
used you in 2004, you'll then want to create a "calculated" field ... go to
a blank column in your query grid and type this in the first line:

Custs2004:Year(YourDateField)

Then in the criteria field of the same column, do this:

=2004

You'll have to change "YourDateField" to match the name of the date field
you're keying off of. This will tell you which customers "used" you in 2004.
Get this done then post back.