append a date even though there is no record

[Quempel]

Hi All

I have 2 tables in which I import data to. Some days there is no data. Is there a way, besides going into the table and entering zero's, to still have a record created with null values?

I have a query which counts the number of records by date, that number is then added to another count of records from a separate table.

Any help would be much appreciated

Missa

 

[lespaul]

you can have a third table with all dates listed. Join to this one and you can show blank or zero for the dates with no data.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design