If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Error message in field
I have a report using a fab ticket for production, using fab ticket number
for the key to tie the report to the sub-reports my sub-reports are for totals of stock items purchased items work labor cost each of the above gives me the total in each of its own queries the labor field is always used, but the other are not. Therefore I get an error message when the field is null the report works great when we have info in all sections I don't know any VBA programing but the things I tried are; iif(Isnull([file name]),0,[file name]) iif(isnull([file name]),0,format([filename],0)) sum(iif([file name]0, true, false) nz([file name],0) -- falvey3 |
#2
|
|||
|
|||
Error message in field
Is your report based directly on a table? Or have you used a query to limit
the data that will be used in the report? Since you didn't provide the error message, it's a bit hard to offer ideas of what might be wrong. Regards Jeff Boyce Microsoft Office/Access MVP "falvey3" wrote in message ... I have a report using a fab ticket for production, using fab ticket number for the key to tie the report to the sub-reports my sub-reports are for totals of stock items purchased items work labor cost each of the above gives me the total in each of its own queries the labor field is always used, but the other are not. Therefore I get an error message when the field is null the report works great when we have info in all sections I don't know any VBA programing but the things I tried are; iif(Isnull([file name]),0,[file name]) iif(isnull([file name]),0,format([filename],0)) sum(iif([file name]0, true, false) nz([file name],0) -- falvey3 |
#3
|
|||
|
|||
Error message in field
I get #Error and #Name?
There is 4 different tables. A query totals the stck, purchase, and labor. I use this totals along with the Fab Tick job info to give me a report sorted on the type of work being done. copy of screen copy from word below CLOSED FAB TICKETS SORTED BY GROUP CODES Group Code P2 Platforms Large (Over 12sf) Work Description FabNo 23 Total of Stock $43.00 WALK PLATFORM PER DRAWING Job No 07-554 Total $836.00 PRIME & PAINT COLOR OF PAINT IS WHITE CostCod 10-295 Total Labor $2,228.00 PLATFORM IS MADE IN SECTIONS TO BE SHIPPED ON A SMALL Qty: 78 SF Cost: $39.833 SF Total All $3,107.00 TRAILER Work Description FabNo 36 Total of Stock $150.00 Testing Program Job No 07-999 Total $524.00 CostCod 10-150 Total Labor $560.00 Qty: 125 SF Cost: $9.872 SF Total All $1,234.00 Work Description FabNo 37 Total of Stock $16.00 Testing Program Job No 07-999 Total $253.00 CostCod 10-241 Total Labor $450.00 Qty: 92 SF Cost: $7.815 SF Total All $719.00 Total 295 SF Total Cost of Group: $5,060.00 Avg Cost per SF $17.15 -- falvey3 "Jeff Boyce" wrote: Is your report based directly on a table? Or have you used a query to limit the data that will be used in the report? Since you didn't provide the error message, it's a bit hard to offer ideas of what might be wrong. Regards Jeff Boyce Microsoft Office/Access MVP "falvey3" wrote in message ... I have a report using a fab ticket for production, using fab ticket number for the key to tie the report to the sub-reports my sub-reports are for totals of stock items purchased items work labor cost each of the above gives me the total in each of its own queries the labor field is always used, but the other are not. Therefore I get an error message when the field is null the report works great when we have info in all sections I don't know any VBA programing but the things I tried are; iif(Isnull([file name]),0,[file name]) iif(isnull([file name]),0,format([filename],0)) sum(iif([file name]0, true, false) nz([file name],0) -- falvey3 |
#4
|
|||
|
|||
Error message in field
copy of report screen copied from ms word below
CLOSED FAB TICKETS SORTED BY GROUP CODES Group Code P2 Platforms Large (Over 12sf) Work Description FabNo 23 Total of Stock $43.00 WALK PLATFORM PER DRAWING Job No 07-554 Total $836.00 PRIME & PAINT COLOR OF PAINT IS WHITE CostCod 10-295 Total Labor $2,228.00 PLATFORM IS MADE IN SECTIONS TO BE SHIPPED ON A SMALL Qty: 78 SF Cost: $39.833 SF Total All $3,107.00 TRAILER Work Description FabNo 36 Total of Stock $150.00 Testing Program Job No 07-999 Total $524.00 CostCod 10-150 Total Labor $560.00 Qty: 125 SF Cost: $9.872 SF Total All $1,234.00 Work Description FabNo 37 Total of Stock $16.00 Testing Program Job No 07-999 Total $253.00 CostCod 10-241 Total Labor $450.00 Qty: 92 SF Cost: $7.815 SF Total All $719.00 Total 295 SF Total Cost of Group: $5,060.00 Avg Cost per SF $17.15 The information is in 4 different tables, I use queries to total the stock, purchases, and labor for each fab ticket. My report is group on the the work being performed then list the fab tickets in order with job number, cost code, qty for u/m for the group, cost of all stock items used, total of all purchased items, and total of hours worked * rate. The stock, purchased, and labor fields are from subform quieries -- falvey3 "Jeff Boyce" wrote: Is your report based directly on a table? Or have you used a query to limit the data that will be used in the report? Since you didn't provide the error message, it's a bit hard to offer ideas of what might be wrong. Regards Jeff Boyce Microsoft Office/Access MVP "falvey3" wrote in message ... I have a report using a fab ticket for production, using fab ticket number for the key to tie the report to the sub-reports my sub-reports are for totals of stock items purchased items work labor cost each of the above gives me the total in each of its own queries the labor field is always used, but the other are not. Therefore I get an error message when the field is null the report works great when we have info in all sections I don't know any VBA programing but the things I tried are; iif(Isnull([file name]),0,[file name]) iif(isnull([file name]),0,format([filename],0)) sum(iif([file name]0, true, false) nz([file name],0) -- falvey3 |
#5
|
|||
|
|||
Error message in field
The Word version of the report's output doesn't provide many clues to how
you've defined the report in Access. If you have a control in your report that shows #Error or #Name, Access is telling you that it cannot figure out what you've told it to put in that control. How did you decide what goes in what control on the report? How did you tell Access? Regards Jeff Boyce Microsoft Office/Access MVP "falvey3" wrote in message ... copy of report screen copied from ms word below CLOSED FAB TICKETS SORTED BY GROUP CODES Group Code P2 Platforms Large (Over 12sf) Work Description FabNo 23 Total of Stock $43.00 WALK PLATFORM PER DRAWING Job No 07-554 Total $836.00 PRIME & PAINT COLOR OF PAINT IS WHITE CostCod 10-295 Total Labor $2,228.00 PLATFORM IS MADE IN SECTIONS TO BE SHIPPED ON A SMALL Qty: 78 SF Cost: $39.833 SF Total All $3,107.00 TRAILER Work Description FabNo 36 Total of Stock $150.00 Testing Program Job No 07-999 Total $524.00 CostCod 10-150 Total Labor $560.00 Qty: 125 SF Cost: $9.872 SF Total All $1,234.00 Work Description FabNo 37 Total of Stock $16.00 Testing Program Job No 07-999 Total $253.00 CostCod 10-241 Total Labor $450.00 Qty: 92 SF Cost: $7.815 SF Total All $719.00 Total 295 SF Total Cost of Group: $5,060.00 Avg Cost per SF $17.15 The information is in 4 different tables, I use queries to total the stock, purchases, and labor for each fab ticket. My report is group on the the work being performed then list the fab tickets in order with job number, cost code, qty for u/m for the group, cost of all stock items used, total of all purchased items, and total of hours worked * rate. The stock, purchased, and labor fields are from subform quieries -- falvey3 "Jeff Boyce" wrote: Is your report based directly on a table? Or have you used a query to limit the data that will be used in the report? Since you didn't provide the error message, it's a bit hard to offer ideas of what might be wrong. Regards Jeff Boyce Microsoft Office/Access MVP "falvey3" wrote in message ... I have a report using a fab ticket for production, using fab ticket number for the key to tie the report to the sub-reports my sub-reports are for totals of stock items purchased items work labor cost each of the above gives me the total in each of its own queries the labor field is always used, but the other are not. Therefore I get an error message when the field is null the report works great when we have info in all sections I don't know any VBA programing but the things I tried are; iif(Isnull([file name]),0,[file name]) iif(isnull([file name]),0,format([filename],0)) sum(iif([file name]0, true, false) nz([file name],0) -- falvey3 |
Thread Tools | |
Display Modes | |
|
|