beginner's question

[XKIMBAL]

I have been using Access for several years now building low end db's and only until recently have I come across this situation for a project I'm working on....

I have information in a table which is a
ProdNum (which repeats for each type of sale)
type of sale (each ProdNum has 1 or 2 never all 4)
count for type of sale for that day

Now the info I receive doesn't include type of sale when count is zero. But on the report I need to show (Grouped by the ProdNum) each type of sale in a specific order and the count including the 0's.

How should I do this? Alter the table, or is there a way to call specific records to specific fields on a report?

Please help.... Thanx

 

[cogent1]

How do you get the info and add it to your table? Presumably you add rows, some of which contain nulls. Run an update query on your table to update all null values to 0

 

[XKIMBAL]

I actually get the info from a space delineated text file. I import it and everything goes smoothly. But here's an example of what I get:

ser# type count
1718 manualsale 7
1718 cdsale 2
1719 cdsale 8
1719 crosssale 1

When I need it to be:
1718 manualsale 7
1718 cdsale 2
1718 crossale 0
1718 additionalsale 0

1719 manualsale 0
1719 cdsale 8
1719 crosssale 1
1719 additionalsale 0


If you have anything for me it will be greatly appreciated... Thanx

 

[cogent1]

You get your data into a new table each time then? And you want to append the data to a master table? Make sure the field names are exactly the same in both tables. All fields must be present in the master table, but not always in the imported table. Construct an Append query which uses the * symbol to select all fields. If a field is not present in the import, a zero will be entered in the missing fields for that row.