Software

Ask something
Discussion Locked

Access 2000 - Mental Block

0 helpful
4 replies

by johngreer

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

This may sound like an Access 101 question but here goes:

I want to design a DB that can do the following:

1) Import data from an external source.

2) parse the data and send each record to a different table (e.g. record 1 goes to TABLE1,record 2 goes to TABLE2, ...)

3) in TABLEn, I want 3 fields that receive data from the insert, and other fields to be populated by formulas (based on input in the new record and other records already in TABLEn).

4) I want to generate charts.

I've designed the DB several times and each time it doesn't do what I want it to do. I've gotten steps 1 and 4 to work, but I'm mystified on how to accomplish steps 2 and 3.

Any pointers would be greatly appreciated.

4 replies

by john_wills

Part 2 is solvable by putting a suitable WHERE in a query; you need to run as many queries as you have destination tables.

I am not sure that Part 3 is a good technique, so why implement it? Why not do the calculation at display? But if you insist on putting calculated values in a table, do so at least partly by INSERT with the column name on SELECT with the formula in your query taking the data from the external source.

by johngreer

Thanks!

1) Is there any way I can use the data in a field as the destination table name?

2) Calculating at display does sound much better. How do I do that?

This discussion is closed to new replies.