Creating a Sales Forecast Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Maybe someone can clue me in - I'm not an Access genious but manage to get
around ok. Here's my case:

1). I've created a database with mulitple tables. Each table is exactly
the same as far as the fields are concern. They are each indvidual sales
persons accounts.

2). I have a master table that I want all of the individual tables to roll
up to.

3). Problem - I'm stumped at the roll-up part. I thought I could build a
relationship and it would automatically update from the individual tables.

4). It ain't happenin' - so any ideas on a simple way of doing this. By
the way I have formulas within the individual table that are also in the
master table.

Thanks to anyone - if you know of another easier way - please clue me in.

Debbie
 
Two tables:

One with all the fields you currently have, plus a field for SalesPersonID

Another table for SalesPerson with an ID field and a Name field (or three)

This design allows you to add more sales people without having to recreate
or alter your queries, forms, etc.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions
 
Debbie,

You should NEVER include calculations or formulas in your table.

They should be created in your queries.

Only data is stored in the tables.

You manipulate the data with queries.

Good Luck!

RRLady
 
Thank you for pointing that out. That's some of my issues!! I deleted the
formulas and are creating queries now.
 

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

Inventory/Sales/Warehouses 6
Expression with a cell reference 1
Sales Forecasting database example 1
Generate Sales Order Number 2
Sales & Purchase 1
Import Information from Excel 1
Order/Inventory/Sales database 8
Complicated Joins In Database 1

Back
Top