General discussion

Locked

Access 2000 - Mental Block

By JohnGreer ·
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.

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access 2000 - Mental Block

by john_wills In reply to Access 2000 - Mental Bloc ...

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.

Collapse -

Access 2000 - Mental Block

by JohnGreer In reply to Access 2000 - Mental Bloc ...

Poster rated this answer

Collapse -

Access 2000 - Mental Block

by JohnGreer In reply to Access 2000 - Mental Bloc ...

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?

Collapse -

Access 2000 - Mental Block

by JohnGreer In reply to Access 2000 - Mental Bloc ...

This question was closed by the author

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums