Access Report Help

[Accessnew2007]

I am trying to complete the following report based on values in a table. The table contains Proposal number, date in, city, state, comments and bid amount. Due to this being a salesmen database, I have yes/no fields for Won, Lost, Active and Working. The salesmen log into a form input then information and save.

The report is where I am having trouble. I want the Report to separate the Won, lost, Active and working. I have completed this with the total bid amount with 100% success; however I can’t put the labels above each Won, lost, Active and Working. I separated the won, lost, active and working by using the grouping function, which gives me the choice for the headers to show. When I put the won title in the won header, it shows in lost, active and working. I can’t figure this out?

[Accessnew2007]

I still after 5 hrs, cant get this too work.......It's like i must be in left field. ANY one please help.....

[pbaldy]

Can you post a picture of the report in design view? Or the db itself?

[Accessnew2007]

The DB is 856K, wont let me load.

[pbaldy]

If you do a compact/repair and then zip, is it small enough to post? Can a record be more than one of those 4? If not, I'd probably have a single status field instead of multiple fields.

[Accessnew2007]

try this.........

[pbaldy]

You didn't address the question of whether a record can have more than one of those fields be true? The normalized setup for this type of thing would be a single "status" field, which is what you would group on in the report.

[Accessnew2007]

Not, records can only be won, lost, active and working. Only four.

[pbaldy]

But can a record be both won and active, or lost and working, etc? If not, I'd use one field.

[Accessnew2007]

Each record can only be one (1) = Won, Active, Lost and working. During the sales process the salesmen may need to go back into a record and change the status. By use one field do you mean lookup column in table? The DB I attached is perfect...the math works fine....it seperates the status perfect, its ONLY the labels that I cant seam to fix....sounds so easy...

[alansidman]

It may work perfectly, but with four fields for status, you could end up with more than one field selected at a time and when you query the status, you will get erroneous information. I would urge you to change it to either a single lookup combo box or an option group. This will make it easier to get your information out in a grouped format as Paul indicated.

Alan

[Accessnew2007]

Ok......I got it....Changed it up and works fine, however now the sort Z thru A does not help. I want the report to follow Won, Lost, Active Working. The report is puting the Working first then Won, Lost and Active due to the Z thru A option in the grouping levels.

[pbaldy]

What sort do you want? Can you post the db? If you want a custom sort, I'd have a table with two fields, those values plus a sort field. Then you sort on the sort field instead of the actual value.