report help

[cbearden]

i have a database that shows the status of titles. i need a report that will group the totals and ONLY show the total amount of each code and percentage of total amt.

if anyone could help, i'd appreciate it
thanks.

 

[RichO]

You description is somewhat vague. How about a little more detail about the fields in your table and how you want them to appear on the report.

 

[cbearden]

the fields in my database are:
date
name
acct
vin
year
make
model
status
rec date

On the report, I'm trying to get the totals and percentage(of the grand total)
The codes are N, Y, S, P.

The report would read as:
N # %
P # %
Y # %
S # %

 

[RichO]

Which field holds the code (N, Y, S, P)? Is the code in a field all by itself or is it part of the Vin # that will need to be extracted?

 

[cbearden]

Which field holds the code (N, Y, S, P)? Is the code in a field all by itself or is it part of the Vin # that will need to be extracted?

the field that holds the codes is called Status Code. On my table, it is a dropdown box that allows some to choose from it. All the other fields(vin, date, etc) i do not need for the report.

 

[Pat Hartman]

Use the report wizard to create the report. Carefully read the options on each wizard page.

 

[RichO]

Generally the report wizard can set this up for you but because you are using only a single field from your table, the report wizard does not offer you all the summary options that you'll need for this field.

Use the wizard to set up a simple report with just the Status field. Go into design view, and select Sorting & Grouping. Choose the Status field and choose Yes for Group Header, a new Status header will appear.

Drag the Status text box from the detail section into the new header and close up the detail section. In the report header (not page header) add a text box with a control source of =Count(*). This is for the overall total. Name this textbox txtTotal. If you don't want this figure to show up on the report, change the visible property to No.

In the Status header add 2 unbound text boxes. One with a control source of =Count(*) and name it txtSubTotal and another with a control source of:

=Int(([txtSubTotal] / [txtTotal]) * 100) & "%"

That should give you the results you're looking for.

 

[cbearden]

thanks, i'll try that.