Query for New Fields in the Table File

K

Ken

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!
 
K

KARL DEWEY

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Some mail merge fields not pulling into document 2
"Compile error in table level validation expression " after format 0
Sumif using partial string 7
Attempting an inventory management database 7
Database to track inventory in company cars 3
SQL Syntax for an update query 2
Linking two tables - a bit different 4
Summarize transations amts on the "Master" record. 3

Top