Report of all items used

[racdata]

Hi all
I have a table where I capture Items (Material) used on a job card. The table have 20 fields for items used. On the form there are 20 Lines that can be used for items used. (ROW 1- Paint, ROW 2 - Brush 25mm, ROW 3 - Brush 75mm, ROW 4 - Cloth.) (Row 1 captured - store in table in Field 1)
Each job card has different items used.
I need a report where all these items used on all the jobcards between two dates are listed. The list must be only list the items, quantity.

I Now include the part of the database that is used for the material report. I explain on the report the format I need.



Thanks

 

[racdata]

Items report

Is their realy no one that can help me with this
Posted on 17 May and had no reply so far

 

[Pat Hartman]

The problem is that your question is confusing. In one sentence you say you have 20 columns with the item data and in the next sentence you say you have 20 rows. Which is it?

 

[racdata]

Listed material

Pat - Sorry for not explaining properly but this is confusing me too.
I hope you can help me now if this is possible - I don't know.

Attached a part of the database

 

[Pat Hartman]

You need to normalize your table. You have several repeating groups that need to be turned into many-side tables. Do some reading on normalization and database design before proceding any further.