report output showing many many rows when all I need is a decimal place.. help!

[AccessForumUser]

hello, I'm looking to build a report to show a final number based on a start and finish range. What I have been getting is many many rows with single instances on my report.. I'd like to take those rows and just have them generate a number based on the output and put them into a box..


Here's what I've done:
1. created a query, added my report criteria colums from my table
2. on my design i've added the "between [start] And [finish]" on the date code so I can grab my search ranges.
- what i see on my report are pages of rows with slighty different outputs showing all the valid data i need, but just in a messy way
- I'd like to take those rows and just have a number generated instead.
3. i've created a text box field and tried adding the Val() command using different options, but I cannot seem to link the output of the query search to the text box to show the valid data as a decimal..

I know i'm missing perhaps a small piece of code somewhere!?

I'm thinking I need to build some type of expression? not sure..

I've attached my database (minus the data)..
I've cleaned it up alot so what you see is the bare bones.

Anyone have any ideas?
Thanks!

[aytee111]

The trick is to get the query working before starting on report design. What is the name of the query? There are no reports in this database so hard to follow your needs.

[AccessForumUser]

I've created a quick query and form to represent what i'm trying to explain.. If you run the frmReport, with date range from 2017-07-01 to 2017-07-30, you'll see 3 records come back showing different outputs.. what i'd like to do is to take those 3 records and make one summary in a decimal format with the text boxes on the form..
the form output is where i'm having the issue.. but it's probably based on some missing expressions in the query? not sure

i'd like to see just a count of how many broken, upgraded, and new phones as a decimal number, not 3 records. I'd like to break apart the table and show the individual count..

The consent phones and final report completed are checkboxes that i'd like to make into a number as well..

Thanks.. hopefully it's not too confusing?

[aytee111]

Forget about forms and reports, get the query(s) working first, showing the data correctly. After that, create a form to select beginning and end dates with a button to open the report.

Use a totals query - that is an E icon at the top of query design. Then you can sum and count and get totals as required. I'm not sure how you know if something is broken or new (etc), but those could be IIF statements in the query.

[AccessForumUser]

thanks for your help. I'm going to try a few things out based on what you recommended today and hopefully it works.. thanks again for the help!