Add or count in a Report

F

FAUSTO

Hello Guys.
Chris helped me with the code needed to display a modelNo
according to values in Table2.
Pls read below.

Chris.
I tried the code and it works the way I expected.
I know you are telling me That I don't need to save
ModelNo in a table but I think I do because next to IMEI
in Table1. I added a Yes/No CheckMark to identify units
on hand.
I know my Boss is going to ask me how many i730, i700,
i1000+,etc, units do we have on hand?

For that purpose I have to create a report or query of
IMEI's that have a CheckMark and also the ModelNo so we
can identify all the IMEI by ModelNo.

In the report I will have something like this:

IMEI OnHand ModelNo QTY
100870249290 Yes i730 1

Also the report should count how many i730 I have on hand.

I know is getting complicated but can you help me pls.

Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Textbox values 2
Uncheck values 2
easy report 1
Report Help pls 0
Help counting multiple checkboxes in a form to make a total in a report 3
Populate automaticaly 1
Auto populate field 1
consignment report 1

Top