Table

R

Rich

I have a table that I track daily numbers, Examp. Date Reading 1, Reading
2, Etc. I enter number readings every day in the table. But I need to track
the diference every day from the readings, any way to do that in a table?
 
D

Duane Hookom

Do you actually have fields for each date? What do you do when you run out of
fields?

I wouldn't go any further until the table structure was normalized. Each
reading should be stored in its own record with the date.
 
J

John W. Vinson

I have a table that I track daily numbers, Examp. Date Reading 1, Reading
2, Etc. I enter number readings every day in the table. But I need to track
the diference every day from the readings, any way to do that in a table?

Tables are designed to store data. Calculations are done in Queries, not in
tables. And as Duane says, your table structure IS WRONG, and must be
restructured if you're ever to get any use out of Access; or we're
misunderstanding the actual structure of your table.
 

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

Top