Results 1 to 4 of 4
  1. #1
    wolfm is offline Advanced Beginner
    Windows 7 32bit Access 2013
    Join Date
    Dec 2013
    Posts
    93

    Cannot create summary counts

    I have a report which prompts the user to enter a start date, end date, and a job number. The result is they get a detailed report of truck runs, for each job in that time frame.
    The query 'Truck Runs Report' takes the criteria and creates the report. The report works great.

    Each truck run is numbered by the Primary Key (ID) from the table 'Truck Runs'. However, my summary field in the report to count the truck runs only counts the lines of truck contents, not the actual truck run itself.



    How do I format the expression in my summary text box to count the Primary Key Job Truck run numbers only, and not all the records containing the contents?


    In other words: count the occurrences of the truck runs numbers appearing on the report. Hope I'm making sense! Help! Thanks!

    Click image for larger version. 

Name:	Capture report.JPG 
Views:	8 
Size:	70.1 KB 
ID:	32522

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    One method would be to create a totals query and bring that in with your record source, then it will be a bound textbox.

  3. #3
    wolfm is offline Advanced Beginner
    Windows 7 32bit Access 2013
    Join Date
    Dec 2013
    Posts
    93
    Thank you. I then created a subreport for the summary query and put it into my main report. The only problem is that users have to enter the parameters multiple times.

  4. #4
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    That is why prompts usually get put on to a form as textboxes, then the queries reference the fields on the form instead of using prompts.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Create Summary Query (Part 2)
    By wdyl121 in forum Access
    Replies: 1
    Last Post: 10-31-2016, 05:14 AM
  2. Create Summary Query
    By wdyl121 in forum Access
    Replies: 1
    Last Post: 10-31-2016, 03:03 AM
  3. Replies: 2
    Last Post: 01-25-2016, 12:21 AM
  4. Replies: 10
    Last Post: 09-25-2015, 05:52 AM
  5. Replies: 0
    Last Post: 11-17-2010, 01:21 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums