AnsweredAssumed Answered

Budget numbers...

Question asked by RandyHandley on Dec 25, 2016
Latest reply on Dec 26, 2016 by philmodjunk

Hi Everyone!

Here is what I am trying to do.... but cant seem to figure it out.

 

Table: Accounts Fields: Code, Account Name, Budget

Record 1 Code: 731200, Account Name: Shoes, Budget: $20,000.00

 

Table: Ledger Fields: Total Spent Shoes, Budget Shoes

 

I am trying to have the budget amount for a certain code show up in a field in the ledger.

 

my thoughts are the IF but that seems to turn out a huge number and not what is already in the record.

 

Accounts: Code =731200 then Ledger: Budget Shoes = $20,000.00

 

I hope this makes sense!

 

Any help would be great!

 

Thanks,

Randy

Outcomes