Urgent Assistance Needed, Please Help

  • Thread starter Thread starter James
  • Start date Start date
J

James

I'm trying to do a university assignment at the moment.
I've got to input data from Excel into Access, which I've
done. I just need to find out how to get Access to total
up figures for me and how to create a database structure
which will allow me to input data for future years into
the database. Any assistance would be greatly
appreciated.
 
Hi,
You can create a new query, selecting the fields that
you want to total, then click on the totals button on the
menu bar. Or you can total your numbers by creating a
report. Try using the wizards.
To enter data, you need a form. Again, try creating it
using the wizards, and choose your table as the data
source.
Hope this helps. Good luck.
 
Hi James, Do up a query of your table using the wizard. Then open up the query in Design View

In the design window, there will be empty columns to the right, unless you might have to add more

In the first line of an empty colum, write a description of that math that your doing ie Tota

Then be sure to add a colon or : after the word total, so you have Total

You can then specify which fields from your query you want to add together. But you have to use the [ ] thingamajigs

For example, Total: [field1] + [field2] + [field3

You can then get creative, Average: [Field1]/[Total]*10

Eskimo going nuts (in the cold)
 
Back
Top