Error message in field

[falvey3]

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)

 

[Jeff Boyce]

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]

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

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

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]

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

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

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)

 

[Jeff Boyce]

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

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

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

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)