Handling a null result in a query...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello All,

I have a form that returns all fields associated with a user-input invoice
number.

After update, a query is run to locate the data from one table associated
with the invoice number entered. Then, a particular field from that query
result is fed to a second query in order to get a date from a second table.
However, if the field from the first query happens to be null, then I get no
results on the form, even though the first query had results. I would like
to be able to still get the results from the first query but if no date can
be found, just leave that form field blank. Is this clear...or possible?

Any help would be much appreciated.

Thanks,

Trevor
 
yes. you need to right join the second query.
an inner join will return nothing if no match is found.
look up/read up on joins in help.
or post your code. i leave work in 30 min so if you post
your code, it may be tomorrow or monday before i can get
to it.
 
Back
Top