Greetings all,
Let's say I have a query that basically pulls ALL information from tblClientInventory.
Now, in the Criteria field under company name, I put in ="PGS" so that it ONLY pulls all records for that company. All is fine up to this point.
... and the results from the query ...
Now, I add tblOutInvoicesC to the query and the query now ONLY pulls records that actually have something in the invoice fields in the tables. Even though I never specified any criteria for the invoice in the query criteria fields AND I still have the company name in the criteria. Even when I remove the company name criteria, the query still ONLY pulls records that have fields with data in the invoice table.
... and the results from the query ...
This also has a problem when there is no entry for the invoice number in the table related to the item in tblInventory... the query basically returns nothing.. a completely empty results page simply because none of the invoices numbers have been populated to the table yet. Shouldn't it just return everything, including blank fields like a normal good boy query?
My question is, why? Just because there are blank fields in a table is no reason to simply nuke all of my records during my search.
Here is an alternate example... in the exact same scenario, I have a field for serial numbers. If a unit does not actually have a serial number, it is no big deal; the query still pulls the record and displays it without any issues. However, as soon as I try to add the invoice table to the query, my data disappears because of empty fields in the invoice number table.
This does not make sense to me. It should operate the same as it does with the missing serial number field data.
I would appreciate any insight anyone has to shed on this. It is probably something simple that I am missing, but I cannot quite figure it out.
Regards.