Variables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an accounting database in which cost centers are tiered into seven
levels. No cost center in a lower tier may charge any cost center above it.
I'm trying to figure out a statement or formula that will look at the tier
number (1,2,3,4,5,6, or 7) and exclude any cost center within a higher
tier...Any suggestions?
 
It will have to be done on a case by case basis. Each time you want to
create a transaction you will need to know the cost center attempting to do
the charge and the cost center to be charged. Then it is just a matter of
comparing the two.

If intChargingTier <= Then
Call CreateTransaction
Else
MsgBox "You can't charge this tier"
End If
 
OK, I was kind of hoping that I could do this with a variable, but if I must
do it on a case by case basis then I guess I'll do it that way...Thanks.

Can I ask you another question? My find feature doesn't seem to be working.
I search for something that is clearly in the table, but I get back a message
saying it is not found???
 
how are you doing the search?

Ray S. said:
OK, I was kind of hoping that I could do this with a variable, but if I must
do it on a case by case basis then I guess I'll do it that way...Thanks.

Can I ask you another question? My find feature doesn't seem to be working.
I search for something that is clearly in the table, but I get back a message
saying it is not found???
Click to expand...
 
Back
Top