Gaps in related table

  • Thread starter Thread starter CW
  • Start date Start date
C

CW

I have an Inquiries table where all our shipping orders are logged (using a
form called Main). Sometimes we have to make shipping crates and when this
occurs there's another form (Crates) on which details are entered and then
saved in the Crates table.
The Inquiries and Crates tables are joined with a type 2 join, using the
common field Ref.
Problem: if we don't have to supply crates on a certain order, that order
doesn't have an entry in the Crates table. When I run my query to look up
all the crate costs that we have incurred, I want every single order to be
shown and if there were no costs for a given order I want 0.00 to be shown,
rather than the record not to be displayed at all.
I have tried changing the type of join between the tables and I have fiddled
around with Nz in the query but nothing has worked so far - advice, please!
Many thanks
CW
 
Show us the SQL of what you have tried. Open the query in design view. Next
go to View, SQL View and copy and past it here.
 
Jerry -
Many thanks for responding but I have just succeeded, having fiddled around
a bit more with Nz I have now got the syntax right and it is displaying 0.00
as I wanted.
Thanks anyway
CW
 
Back
Top