Tables not adding up ? but queries are

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

Guest

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
 
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.
 
You must log in or register to reply here.

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

acnewrec? 1
Access Dcount (multiple criteria) 3
VBA - retrieve data on last create named range from previous inserted named range 0
Query based on multiple tables 2
Can't create a report from my query in Access 1
Calculations, Queries and making it all come together in my table 4
Access Access Report Works on One Machine but not Another 3
Show the date of the last time the query was run 8

Back
Top