G
Guest
background is: Job>Product>Tickets. This has to be further broken down for
one particular customer because we are having to stockpile the product at
various locations, ie: 500 tons of # 6 stone at site A, 300 tons # 6 stone
at site B, etc. I have to track how much material is stockpiled at each
location. I'm not having any problems with the tables, queries, forms, etc.
The problem comes in with the reports.
My reports are getting just too dang big!! Right now, I've got it broken
down as two reports, completed and not completed...ie I use a checkbox on my
form and when we complete the (example 500 tons site A) haul for site A click
complete button. The report looks at the yes/no field before running and
depending on the value of the field bases the query for the report.
Problem is, my report will only support 26 columns (a-z column headers,
thanks to Duane Hookom for her column alias which I've actively used with a
few tweeks such as modifying the table so I can use it with several different
procedures, all column aliases) and it's legal sized. It won't grow any
wider, but I need it to... I already have each product separate... any other
suggestions?
Note: right now, on one job for this customer, there are 88 different
stockpile locations, of which all but 6 are complete.
one particular customer because we are having to stockpile the product at
various locations, ie: 500 tons of # 6 stone at site A, 300 tons # 6 stone
at site B, etc. I have to track how much material is stockpiled at each
location. I'm not having any problems with the tables, queries, forms, etc.
The problem comes in with the reports.
My reports are getting just too dang big!! Right now, I've got it broken
down as two reports, completed and not completed...ie I use a checkbox on my
form and when we complete the (example 500 tons site A) haul for site A click
complete button. The report looks at the yes/no field before running and
depending on the value of the field bases the query for the report.
Problem is, my report will only support 26 columns (a-z column headers,
thanks to Duane Hookom for her column alias which I've actively used with a
few tweeks such as modifying the table so I can use it with several different
procedures, all column aliases) and it's legal sized. It won't grow any
wider, but I need it to... I already have each product separate... any other
suggestions?
Note: right now, on one job for this customer, there are 88 different
stockpile locations, of which all but 6 are complete.