expression

  • Thread starter Thread starter Valerie
  • Start date Start date
V

Valerie

I have a report which will pull information on product
transactions, what was bought & sold and when. I would
like to create one control to identify the transaction
which would pull from one of two fields depending upon
which one contains a value. For example, if we purchased 5
of this product on 1/15, the report is going to tell me
that. If we sold 3 of the same product on 1/18, it's going
to tell me that as well. What I want to do is pull the
corresponding purchase order number for the 1/15 purchase,
and the corresponding sales order for the 1/18 sale.

I'm thinking it would be something along the lines of if
PO # has a value, then let's go with that value. If the PO
# field does not have a value, then let's pull the sales
order #.

Now all I need to know is how to put that in Access lingo.
Any help would be most appreciated.

I know I could just use two separate controls in my
report - one for PO# and one for SO# - but that takes all
the fun out of it!

Valerie
 
Valerie,

I think you will need to give us a bit of an outline of your table
structure, and where the data relating to PO# and SO# and Product
purchsed and sold is located, before anyone will be able to be much use
to you.

By the way, as an aside, it is not a good idea to have a # as part of
the name of a field or control or database object.
 
Back
Top