Query for New Fields in the Table File

[Guest]

Our consultant just programed and added two new fields (Job number & Employee
number) in an inventory transaction table file for our accounting system.
Then, in Access, I created a query using only the table with those two new
fields. The query result shows ONLY the transactions after we installed the
newly programed fields.

My quesion is how I can create a query showing all the transactions with AND
without the two new fields.

Thank you very much!

 

[Guest]

The fields for all prior transactions are null. Revise your queries to
accept nulls or update all the nulls with something.

Backup the database first.

The something will be based on the datatype -- number = 0, Text = "" as zero
lenght string, boolean = 0 for No or not checked, etc.