Append Query to make 1 record!

[dmeid]

I have created 4 different tables from multiple calculating queries and forms in order to produce a final field to be placed on a report. I know reports can only have 1 record source table. ( DLookUp doesn't work efficient enough for what I need).

I am trying to consolidate these 4 tables (which only have 1 record in each table) into 1 table with only 1 record. I have created a new table with all these field with correct field types.(duplicating the orginating tables.)

When I run this append Query I get 0 records copied to the new Table ... without any errors popping up.

Why will it not copy any fields to the new table?

Thanks to you in advance! D

 

[dmeid]

I have figured out the problem......why I get 0 records.

On 1 of my tables is has 0 records ...... so obviously it doesn't load the new table with any fields.

Possibly I need to put a criteria in each cell "If not Null" ??????