• WS79schultz

    WS79schultz

    @ws79schultz

    Viewing 15 replies - 211 through 225 (of 259 total)
    Author
    Replies
    • in reply to: Clipboard/Slow closing (Access 2003/SP 1) #990530

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

    • in reply to: Order Total (Access 2003/SP 1) #983882

      Thanks for the explanation!

    • in reply to: Order Total (Access 2003/SP 1) #983876

      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.

    • in reply to: Order Total (Access 2003/SP 1) #983861

      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!

    • in reply to: Making a Batch File (XP/Pro/2002/SP2) #979118

      Thanks. I tried that and it works!

    • in reply to: Making a Batch File (XP/Pro/2002/SP2) #979117

      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.

    • in reply to: Making a Batch File (XP/Pro/2002/SP2) #979098

      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.

    • in reply to: Disk Cleanup-How often? (XP/Pro/2002/SP2) #975616

      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.

    • in reply to: Parameter Query/Double Entry (Access 2003/SP 1) #975431

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

    • in reply to: Parameter Query/Double Entry (Access 2003/SP 1) #975425

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

    • in reply to: Parameter Query/Double Entry (Access 2003/SP 1) #975394

      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;

    • in reply to: File Format (Access 2003/SP 1) #970369

      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.

    • in reply to: Entering Data in Subform (Access 2003/SP 1) #968914

      That did it! Thanks for the help!

    • in reply to: If IsNull then N/A (Access 2000) #951124

      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.

    • in reply to: Envelope-Default return address (Word 2000 (SP3)) #929802

      Merci beaucoup! That fixed the problem! thankyou

    Viewing 15 replies - 211 through 225 (of 259 total)