If Statement

[Brook]

Good Day,

I am working with a table houseing my business expenses. The table includes
items from my checking account (Deposits & Checks written), cash purchases,
and Wires.

Within this table I have 3 yes/no check boxes. "Wire", "CheckingAccount",
& "AddtoExpenseReport".

What I am trying to do is this:

Create a query that will look at the the "Wire" yes/no check box and if
this is "TRUE", then move the "debited wire amount" Column to the "Credit
Amount" Column.

Is this possible?

Please let me know if this is unclear or if you need more information.

Thanks,

Brook

 

[Jeff Boyce]

Brook

You have multiple columns for amounts?

Another approach might be to have a single column for amount, and a
"classifying" column that you use to categorize the amount as a <Credit>, or
<Debit>, or however else you need categorize it.

 

[John Spencer (MVP)]

How about using an update query that looks like the SQL below.

UPDATE YourTable
SET [Credit Amount] = [Debited Wire Amount],
[Debited Wire Amount] = 0
WHERE Wire = True