easy report

[oscar]

Hi guys.

Please be very patient with me. I need help with this
small but important project.
The db mentioned below can be downloaded to help me
better ( http://www.geocities.com/nextelito/db1.mdb )and
can be sent back to me to the following temp e-mail:
(e-mail address removed)

Questions?
1= How can I get the field ModelNo in "form1" to display
the model nunber automaticaly according to the data in
Table (Model)
For example notice that in Main table there is a Column
called SentIMEI and ReplacementIMEI which its last 3
digits of every entry ends with 100 , 200, 300 or 400
last 3 digits. Well the last 3 digits will determine the
model number according to the values in Column "ModelNo"
&"digits" in Table named"MODEL"

For example if I enter a number in the SentIMEI or
ReplacementIMEI number in "Form1" (Example 878787100)
then the modelNo will display "A"

2= How can I get a report of only units sentOut but not
received yet?
In other words I need a print out of all SentIMEI that
has a check mark SentOut but not Received yet. That will
give a number of units that I have on hand or That I can
count with.

Thank you guys.

 

[Larry Linson]

Oscar, with viruses, worms, and trojans so common, it is rare that anyone
will download and open a file (or open an attached file), even if they have
time/energy to spend debugging someone's work. It is much more productive if
you carefully, in detail, describe what you have, and what the problem is.

Larry Linson
Microsoft Access MVP