C
Cindy
Hi,
I have created an asset inventory database to track my
assets.
What I would like to do is create a report where when you
choose an employee number/name you get a list of the
employee's assets they own.
When the employee is selected from a list I would just
like certain fields to appear such as asset #, make,
model, serial # etc. in my table.
With the field asset #. I have designed my database to
put a letter in front of each asset that identifies what
type of asset it is. For ex. PC00250 I need to read the
first letter and from that result place what type it is in
a text field. Ex: If "P" then display "Printer" in the
text field
Would this be easier in a form and then just print out the
form?
Would anyone know a way of doing this? Any help is
appreciated..
Thanks..
I have created an asset inventory database to track my
assets.
What I would like to do is create a report where when you
choose an employee number/name you get a list of the
employee's assets they own.
When the employee is selected from a list I would just
like certain fields to appear such as asset #, make,
model, serial # etc. in my table.
With the field asset #. I have designed my database to
put a letter in front of each asset that identifies what
type of asset it is. For ex. PC00250 I need to read the
first letter and from that result place what type it is in
a text field. Ex: If "P" then display "Printer" in the
text field
Would this be easier in a form and then just print out the
form?
Would anyone know a way of doing this? Any help is
appreciated..
Thanks..