easy report

  • Thread starter Thread starter oscar
  • Start date Start date
O

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.
 
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
 
Back
Top