Report help for cutter inventory

[podge2011]

Hi all

Had to make an inventory for work,which is nearly finished.The Inventory
holds all the stock cutters we have. Can someone help me with the report
i am trying to create.There is a report in the db but i want all the cutters to be grouped by cutter type and not by cutter id no.I have tried this in a report but instead of the cutter type name i get the cutter type id number.

Regards

Podge

[Robeen]

I just opened your db and created a new report using the Report Wizard - and had no problem grouping the report by Cutter Type.

Why don't you just re-create the report?
Copy the ReportHeader over from the other report if you need . . .

I'm attaching a screenshot of what the report looks like with the Cutter Type Grouping. Is that how you want it to be?

[podge2011]

Hi M8

Thats what i did.If you look at the cutter type table those numbers correspond to a cutter type(dp hop,dp shaper etc).These cutter types i want as the group headings ,not the numbers.
Thanks for taking the time to help me out.

[Robeen]

Cutter TYPE 2 = DP SHAPER?
CUTTER TYPE 3 = DP HOB?
CUTTER TYPE 4 = MOD SHAPER?

etc . . .

[podge2011]

Yes thats it.Instead of the numbers being the group heading,i need dp hob etc.
Thanks

[Robeen]

The CUTTER TYPE field in your 'CUTTER INVENTORY' table is a Lookup field and it is defined with a data type of 'Number'.
So - if you use that field in your report - it will give you the '[CUTTER TYPE].[ID]] value - which will be a number.

Plus - something is not right in the way you have created the relationships between CUTTER INVENTORY and CUTTER TYPE.
The reason I say this is that if the relationships are correct - then I should be able to pull those two tables into a query - add fields and the query should work - right?
When I do that I get a Type Mismatch message.

Here's what I did.

I created a query [Query1] with CUTTER INVENTORY and CUTTER TYPE tables.
I deleted both the join lines.
I created a join line between [CUTTER INVENTORY].[CUTTER TYPE] and [CUTTER TYPE].[ID]. (Screenshot).
Pulled in all fields from [CUTTER INVENTORY] - EXCEPT [CUTTER TYPE].
I pulled in the [CUTTER TYPE] field from the [CUTTER TYPE] table.
Query1 runs fine.
Then I created a new report based on this query & grouped on [CUTTER TYPE].[CUTTER TYPE] field.
Voila!
See screenshots.


Hope this helps!!!

[podge2011]

Thats it.Thanks, your help and time is much appreciated.

Regards

Podge

[Robeen]

Happy to Help!