Tables not adding up ? but queries are

M

Matthew

hello here.. new to access & building first databse. i have setup a tables &
queries. i have 1 table & query of the same fields. all of the fields are
adding up in a query but when viewing the data in a table, the fields are not
adding up in the table. any help would be appricated. thanks
 
F

fredg

hello here.. new to access & building first databse. i have setup a tables &
queries. i have 1 table & query of the same fields. all of the fields are
adding up in a query but when viewing the data in a table, the fields are not
adding up in the table. any help would be appricated. thanks
Click to expand...

What do you mean by not adding up in the table?
Are you trying to do calculations in the table? You can't!
Tables are for storing data. If you need to calculate using that data,
do it in a query, as you have, or in a form or report control.
 
Top