Replies

I understand the message, my question is: Are there any settings in Clipboard to turn that off?

Thanks for the explanation!

Thanks 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.

I 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!

Thanks. I tried that and it works!

I 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.

I 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.

Thanks 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.

That did the trick. Thanks a lot for your help!!

I 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”)

Edited 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;

Thanks 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.

That did it! Thanks for the help!

Thanks a lot! That’s exactly what I needed. Just a question. What does ‘@’ mean in Access? I’ve seen it used in other instances.

Merci beaucoup! That fixed the problem!