Field Value according to another table

[Guest]

Hi, I hope you can help me out.

I am creating a pick list for surgeries. Some of the items we can charge
for, but not everything. In my database, I have a table with all of the
numbers of the items we can't charge for.

When I print the listing, I would like to be able to put an asteriks or some
other symbol in front to denote that this is not a chargeable item.

Any Suggestions, or if I can explain further, let me know.

Thanks
Harv

 

[Terry]

Harv,

I am making a couple of assumptions here:
Somewhere you have a yes/no field to indicate chargable
services. You will need to substitute your field names.

In the control source f a text field:

=IIf([chargeable]=Yes, [ItemToList], "*" & [ItemToList])

Should display an * before items which are not chargeable.

HTH

Terry
PS if you need more assistance some field names and data
structure would help.

 

[Guest]

Thanks for responding, Terry.

Let me explain better, I have two tables, [InventoryItems] and
[NonChargeableItems].
[InventoryItems] has fields, InvNum, Description, OurCost.
[NonChargeableItems] has field InvNumber (Would be like InvNum above).

If an item [InventoryItems].InvNum is listed in
[NonChargeableItems].InvNumber then I would like to have a designating
character placed in front of it.

Hope that is more descriptive.
Thanks for the info

Harv,

I am making a couple of assumptions here:
Somewhere you have a yes/no field to indicate chargable
services. You will need to substitute your field names.

In the control source f a text field:

=IIf([chargeable]=Yes, [ItemToList], "*" & [ItemToList])

Should display an * before items which are not chargeable.

HTH

Terry
PS if you need more assistance some field names and data
structure would help.

-----Original Message-----
Hi, I hope you can help me out.

I am creating a pick list for surgeries. Some of the items we can charge
for, but not everything. In my database, I have a table with all of the
numbers of the items we can't charge for.

When I print the listing, I would like to be able to put an asteriks or some
other symbol in front to denote that this is not a chargeable item.

Any Suggestions, or if I can explain further, let me know.

Thanks
Harv
.