Error in field

[dakwest]

I have two queries and have setup a relationship between the two. Q1 has several thousand records. Q2 has about 1000 records. There is only one record in Q2 that relates to a record in Q1. I want to create a Third Query that contains only a few fields from each of the first two queries. The problem is that when I create a field to contain data from Q2, if there is no record found, this field contains "#error". I would like to have the field contain nothing. I cannot seem to figure this out. Help would be appreciated.
Thanks

[CGM3]

The code for the queries would be helpful to find the problem. And does the "#error" show up in the query, or a report using the query as its source? If the latter, you can use this formula in the text field--

=IIf(IsError([field]),"",[field])

--where "field" is the field involved.

[dakwest]

The #error shows up in the Query I am trying to create. In this Query, I am creating an expression called "Size". I want the data to come from the field "Net2Price" in Q2. Since not all records in Q1 have a related record in Q2, the error is generated for the records with no match. The formula I tried is this:

Size: iif(iserror(Net2Price),0,Net2price)

In the records that match, Size is value of Net2Price, but in the fields where there is no match, I get "#error". I want instead to have this value at 0.

[dcrake]

It sounds like you are attempting to calculate a figure based on entities from two different queries. However if one side of the equasion is missing then you will get an error - as expected.

X- Nothing = Error
X-0 = X

Therefore in each of your queries you need to ensure that no Null or Blank fields are returned.

David