-
WS79schultz
AskWoody LoungerI understand the message, my question is: Are there any settings in Clipboard to turn that off?
-
WS79schultz
AskWoody LoungerThanks for the explanation!
-
WS79schultz
AskWoody LoungerThanks a lot for your help! That worked. Can you explain to me the difference in function of the ‘.’ and the ‘!’? I had the control source like this =[sbfOrder Details].Text20 first and that didn’t work.
-
WS79schultz
AskWoody LoungerI think I mis-spoke myself when I said I want a running total. The subform works how I want it to. All I need is the text69: field (I’ll rename it when I get it figured out) to give me a sum of my order. I appreciate the help on the running total though!
-
WS79schultz
AskWoody LoungerThanks. I tried that and it works!
-
WS79schultz
AskWoody LoungerI understand that step, and yes it is easier. However I am wanting to make something that I can set up on a schedule to backup nightly for me where I don’t have to do it manually.
-
WS79schultz
AskWoody LoungerI followed your advice and it didn’t work. I just see a 1/2 second flash of a MSDOS window. Do I need to add the full pathname? The full path name is like this: C:Documents and SettingsWeldon SchultzMy DocumentsAccess.
-
WS79schultz
AskWoody LoungerThanks for the info. I don’t know enough about computers to know really what is harmful or not. When I had Windows 98 I ran Disk Cleanup and Defrag on the Task Scheduler. I occasionally run CHKDSK also. I think I’ll continue on the way I’ve been doing it.
-
WS79schultz
AskWoody LoungerThat did the trick. Thanks a lot for your help!!
-
WS79schultz
AskWoody LoungerI understand the concept you are talking about, but I’m lost as to how to put it into my query. I’ve seen that in other sample databases but can’t remember where. Is it something like this? Date: Format([Date],”mmmm”)
-
WS79schultz
AskWoody LoungerEdited by HansV to correct problems with field name starting with “tr” (it is interpreted as a table row tag by the Lounge software)
Here it is:
SELECT [dataInt Tract Totals].Country, Sum([dataInt Tract Totals].[Tract Totals]) AS [SumOfTract Totals], Sum([dataInt Tract Totals].Packages) AS SumOfPackages, Sum([dataInt Tract Totals].[Letter Count]) AS [SumOfLetter Count], Sum([dataInt Tract Totals].Bibles) AS SumOfBibles, Sum([dataInt Tract Totals].[New Testaments]) AS [SumOfNew Testaments], Sum([dataInt Tract Totals].[Gospel of John]) AS [SumOfGospel of John], Sum([dataInt Tract Totals].Books) AS SumOfBooks, Sum([dataInt Tract Totals].SSQ) AS SumOfSSQ, Sum([dataInt Tract Totals].MOT) AS SumOfMOT
FROM [dataInt Tract Totals]
GROUP BY [dataInt Tract Totals].Country
HAVING ((([dataInt Tract Totals].Country) In (SELECT [Country] FROM [dataInt Tract Totals] As Tmp GROUP BY [Country] HAVING Count(*)>0 )))
ORDER BY Sum([dataInt Tract Totals].[Tract Totals]) DESC;I made this query probably 2 years ago when I was learning how to use Access. ( I still am) I have it referenced to a query that pulls specific data by date. The query it pulls data from (dataInt Tract Totals) pulls the data I want but I need to know the sum of each class by country and it shows the sum for every date, not by month. I know there’s a solution and I can probably do it in 1 query, but haven’t figured it out.
Here is the SQL view of the original query.
PARAMETERS [Enter beginning date] DateTime, [Enter ending date] DateTime;
SELECT tblInternational_Orders.Country, tblInternational_Orders.[Tract Totals], tblInternational_Orders.Sent, tblInternational_Orders.Packages, tblInternational_Orders.[Letter Count], tblInternational_Orders.Date, tblInternational_Orders.Bibles, tblInternational_Orders.[New Testaments], tblInternational_Orders.[Gospel of John], tblInternational_Orders.Books, tblInternational_Orders.SSQ, tblInternational_Orders.MOT
FROM tblInternational_Orders
WHERE (((tblInternational_Orders.Country) In (SELECT [Country] FROM [tblInternational_orders] As Tmp GROUP BY [Country] HAVING Count(*)>0 )) AND ((tblInternational_Orders.Date) Between [Enter beginning date] And [Enter ending date]))
ORDER BY tblInternational_Orders.[Tract Totals] DESC; -
WS79schultz
AskWoody LoungerThanks for the information. That’s kind of what I was thinking that I’d leave it in 2000 format. At this point I haven’t made an .mde file as we have just 3-4 users and I’m green enough with Access that I’m not sure I’m ready for it.
-
WS79schultz
AskWoody LoungerThat did it! Thanks for the help!
-
WS79schultz
AskWoody LoungerThanks a lot! That’s exactly what I needed. Just a question. What does ‘@’ mean in Access? I’ve seen it used in other instances.
-
WS79schultz
AskWoody LoungerFebruary 19, 2005 at 11:45 pm in reply to: Envelope-Default return address (Word 2000 (SP3)) #929802Merci beaucoup! That fixed the problem!
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Suggestions for New All in One Printer and a Photo Printer Windows 10
by
Win7and10
1 hour, 13 minutes ago -
Purchasing New Printer. Uninstall old Printer Software First?
by
Win7and10
1 minute ago -
KB5060842 Issue (Minor)
by
AC641
4 hours, 34 minutes ago -
EchoLeak : Zero Click M365 Copilot leak sensitive information
by
Alex5723
7 hours, 7 minutes ago -
24H2 may not be offered June updates
by
Susan Bradley
1 hour, 35 minutes ago -
Acronis : Tracking Chaos RAT’s evolution (Windows, Linux)
by
Alex5723
19 hours, 40 minutes ago -
Turning off OneDrive
by
CWBillow
1 day ago -
June 2025 updates are out
by
Susan Bradley
3 hours, 1 minute ago -
Mozilla shutting Deep Fake Detector
by
Alex5723
1 day, 10 hours ago -
Windows-Maintenance-Tool (.bat)
by
Alex5723
19 hours, 49 minutes ago -
Windows 11 Insider Preview build 26200.5641 released to DEV
by
joep517
1 day, 12 hours ago -
Windows 11 Insider Preview build 26120.4250 (24H2) released to BETA
by
joep517
1 day, 13 hours ago -
Install Office 365 Outlook classic on new Win11 machine
by
WSrcull999
1 day, 12 hours ago -
win 10 to win 11 with cpu/mb replacement
by
aquatarkus
1 day, 4 hours ago -
re-install Windows Security
by
CWBillow
1 day, 16 hours ago -
WWDC 2025 Recap: All of Apple’s NEW Features in 10 Minutes!
by
Alex5723
1 day, 19 hours ago -
macOS Tahoe 26
by
Alex5723
1 day, 14 hours ago -
Migrating from win10 to win11, instructions coming?
by
astro46
1 hour, 17 minutes ago -
Device Eligibility for Apple 2026 Operating Systems due this Fall
by
PKCano
1 day, 4 hours ago -
Recommended watching : Mountainhead movie
by
Alex5723
1 day, 5 hours ago -
End of support for Windows 10
by
Old enough to know better
12 hours, 57 minutes ago -
What goes on inside an LLM
by
Michael Covington
23 hours, 36 minutes ago -
The risk of remote access
by
Susan Bradley
6 hours, 48 minutes ago -
The cruelest month for many Office users
by
Peter Deegan
7 hours, 27 minutes ago -
Tracking protection and trade-offs in Edge
by
Mary Branscombe
1 day, 9 hours ago -
Supreme Court grants DOGE access to confidential Social Security records
by
Alex5723
2 days, 18 hours ago -
EaseUS Partition Master free 19.6
by
Alex5723
1 day, 18 hours ago -
Microsoft : Edge is better than Chrome
by
Alex5723
3 days, 7 hours ago -
The EU launched DNS4EU
by
Alex5723
3 days, 20 hours ago -
Cell Phone vs. Traditional Touchtone Phone over POTS
by
280park
3 days, 10 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.