A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Error message in field



 
 
Thread Tools Display Modes
  #1  
Old July 20th, 2007, 04:42 PM posted to microsoft.public.access.reports
falvey3
external usenet poster
 
Posts: 3
Default 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  
Old July 20th, 2007, 05:00 PM posted to microsoft.public.access.reports
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default 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  
Old July 20th, 2007, 06:12 PM posted to microsoft.public.access.reports
falvey3
external usenet poster
 
Posts: 3
Default 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  
Old July 20th, 2007, 06:18 PM posted to microsoft.public.access.reports
falvey3
external usenet poster
 
Posts: 3
Default 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  
Old July 20th, 2007, 07:03 PM posted to microsoft.public.access.reports
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.