Improve company productivity with a Business Account.Sign Up

x
?
Solved

Total on datasheet view in strange spot

Posted on 2014-01-25
4
Medium Priority
?
518 Views
Last Modified: 2014-01-29
Please see attachment.

I can't figure out why the word "Total" is showing up in this strange spot on a form datasheet view.  Why is it showing up under "Shipped Y/N" and why can't I move it?

--Steve
Total-Screen-Shot.jpg
0
Comment
Question by:SteveL13
  • 2
  • 2
4 Comments
 
LVL 50

Expert Comment

by:Dale Fye
ID: 39808853
If you open the data sheet in design view, then go to the "home" tab on the ribbon,  you will see a summation symbol (sigma) at the top center of the ribbon.  Unselect that and the total row in the data sheet will go away.  Then save the data sheet when you close it.
0
 

Author Comment

by:SteveL13
ID: 39808880
That removes the total row.  But when I re-click on Totals the word "Total" comes back in the strange spot.

Plus in design view the Sigma symbol is grayed out.
0
 
LVL 50

Accepted Solution

by:
Dale Fye earned 2000 total points
ID: 39808972
Sorry, I was working from my ipad and was working from memory.

By strange spot, do you mean that it is showing up in the 3rd column instead of the first?

Do you not want the datasheet totals line to show at all, or do you just not want to display the term "Total"?

You are correct, if you want to turn it off, you have to have the datasheet open in datasheet view (by itself, not as a subform).  Then you need to unclick the "Totals" option on the Records section of the "Home" tab.  Then you have to save the form before you close it.  Once you have done that, the Totals line will be gone, until you turn it on again.
0
 

Author Comment

by:SteveL13
ID: 39809348
Yes, I understand.  But the word "Total" keeps coming back in the wrong place.  I don't want it to be in the 3rd column but actually in the first column.  Is very strange.
0

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
If you need to implement application level security in an Access database application or other VBA code, I strongly encourage you to take advantage of Active Directory groups.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question