combine tables with sales data

[Guest]

I need to combine tables with sales data in them. There will be one table
per month addedto the table in progress. It needs to be datasheet style. On
the same row you would see the customer name and all sales for Janurary and
the all sales for February etc. I am struggling with the zero sales (New
Customers) and the null records that are null in one table and not in the
other. The data needs to be one continuous row. The problem I am having is
that there may have been sales in February but none in March so there needs
to be blank or null records included. The table field names are the same
accept they have the new month infront of the field name. January
Sales.Sales Rep, February Sales.Sales Rep etc. all on one row in the table.

 

[Jeff Boyce]

Susan

From your description, you are working in a ... spreadsheet! Since Access
is a relational database, your approach will only cause both you and Access
severe headaches.

Take a break and look into "normalization", which you will need to do if you
are to get benefit of Access' features and functions.

Note: just because the data "comes" to you in a spreadsheet organization
doesn't mean you need to keep that structure in your Access tables.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Thank you very much for your help. I had thought about the fact that the
data is somewhat redundant in spreadsheet. I will take a look from a
different perspective and see if I can make it work. The only restraint I
have is that when I give the data back it needs to be in an excel
spreadsheet.

I know that Access does not like null values but is there an easy way to
create a query that will show all the data in the tables even if there are
null values for some of the months?

Thanks again.

 

[Jeff Boyce]

Access has ways to handle nulls.

If you want Access to output something similar to a spreadsheet, look into
"Crosstab queries".

Good luck!

Jeff Boyce
Microsoft Office/Access MVP