Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Displaying Sums Only
I have built a query into an Access database and am only interested in
displaying the sum. Is there a way to only display the sum total and not all the data, followed by the sum? Thanks |
#2
|
|||
|
|||
If you post your question in the Access Queries newsgroup
(microsoft.public.access.queries), someone should be able to help you. SCW wrote: I have built a query into an Access database and am only interested in displaying the sum. Is there a way to only display the sum total and not all the data, followed by the sum? Thanks -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Hi SCW,
In yhe VBE, with your project selected: Tools | Project Properties | Select the 'Protection' tab | Enter & Confirm your password | select the Lock Project option | OK Save, Close and reopen the workbook. --- Regards, Norman "SCW" wrote in message ... I have built a query into an Access database and am only interested in displaying the sum. Is there a way to only display the sum total and not all the data, followed by the sum? Thanks |
#4
|
|||
|
|||
Hi SCW,
Sorry, this was sent in error . It was intended as a response to another question. --- Regards, Norman "Norman Jones" wrote in message ... Hi SCW, In yhe VBE, with your project selected: Tools | Project Properties | Select the 'Protection' tab | Enter & Confirm your password | select the Lock Project option | OK Save, Close and reopen the workbook. --- Regards, Norman "SCW" wrote in message ... I have built a query into an Access database and am only interested in displaying the sum. Is there a way to only display the sum total and not all the data, followed by the sum? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUP FUNCTION WITH SUMS ABILITY | Excel Discussion (Misc queries) | |||
LOOKUP FUNCTION WITH SUMS VALUES | Excel Discussion (Misc queries) | |||
Stopping Charts Displaying Zero Results | Charts and Charting in Excel | |||
Displaying a blank cell | Excel Discussion (Misc queries) | |||
when displaying formulas, how to start a new line in the same cel. | Excel Discussion (Misc queries) |