IsError on #Error wont work?

  • Thread starter Thread starter vqthomf
  • Start date Start date
V

vqthomf

Hi I am trying to join two queries together but I am getting an #Error, I
have tried to use IsError but this wont work can someone please put me on the
right track.
Regards Charles

Query 1
Dept Daily_Ins Line
AF 24 1
AF 33 2
Paint 10 1
Paint 11 2
PO 4 1
PO 1 2
VQ 17 1
VQ 35 2
Weld 29 1
Weld 6 2

Query 2
Dept CarryOver_Stock Line
AF 6 1
AF 10 2
NM 3 1
Paint 7 1
Paint 12 2
PO 1 1
PUR 1 1
VQ 6 2
VQ 6 1
Weld 1 2

Joined query
Dept Daily_In Line
AF 32 1
AF 42 2
Paint 17 1
Paint 23 2
PO 5 1
PO #Error 2
VQ 23 1
VQ 42 2
Weld #Error 1
Weld 7 2
 
Post the 3 query statements (by switching to SQL View.)

Also indicate the data type of each field in the JOIN or expression.
(Open the table in design view to see the field's Data Type.)
 
Thanks Allen I have sorted it by creating a new column and using a iif with
isnull function and then do my cals using this column.
Regards Charles
 
vqthomf said:
Hi I am trying to join two queries together but I am getting an #Error, I
have tried to use IsError but this wont work can someone please put me on
the
right track.
Regards Charles

Query 1
Dept Daily_Ins Line
AF 24 1
AF 33 2
Paint 10 1
Paint 11 2
PO 4 1
PO 1 2
VQ 17 1
VQ 35 2
Weld 29 1
Weld 6 2

Query 2
Dept CarryOver_Stock Line
AF 6 1
AF 10 2
NM 3 1
Paint 7 1
Paint 12 2
PO 1 1
PUR 1 1
VQ 6 2
VQ 6 1
Weld 1 2

Joined query
Dept Daily_In Line
AF 32 1
AF 42 2
Paint 17 1
Paint 23 2
PO 5 1
PO #Error 2
VQ 23 1
VQ 42 2
Weld #Error 1
Weld 7 2
Click to expand...
 
Back
Top