Excel To Access

[Pam]

Hi,

I have a report that is based on information in Access. It tracks periods
of time for each job - quoted to approved to repaired to complete. I ran
query and put all records to an Excel spreadsheet. Boss has come back with
extensive calculations that he wants to put in a report in Access to run on
regular basis instead of calculating in Excel each time data changes.

The first problem is the report is based on field model, but not all
distinct models. For example, Unit Type = Acme, Model = A1, A2, A3. Need
group for A1's, A2's, and A3's and then group ALL Acme.

The second problem is the footer calculations for each group. This report
will cover 2006-2008 year to date. I need a count for all jobs in each
group for 2006-07 with field InvoiceDate between 1/1/06 and 12/31/07 and a
count for all those so far in 2008. I tried several different IIf
statements but kept getting comma error.

If anyone has a solution as to how I can create this report in Access, I
would greatly appreciate it.

Thanks in advance for any help available.
Pam

 

[Duane Hookom]

You should use values stored in fields in tables to group models. If you
don't have a field to store this information, add it.

To count records meeting a specific condition in a report section, you can
add a text box to the header or footer with a control source like:
=Sum(Abs({your true/false condition}))
maybe
=Sum(Abs([InvoiceDate]<#1/1/2008#))