Recent content by Stayingahead

Thanks. That worked. I was trying to make something simple, difficult.

I am pulling financial info from a "table view" from our central office. Problem is all transaction amounts show up as a positive figure. I need to write an IIF statement to show Voided Deposits and withdrawls as negative figures. Below is all the codes I have to include or work with...

I must be having a brain malfunction today. What do you mean or how to do it?

I have created a table that uses a autonumber as the primary key which is linked to other tables. I have removed all links, deleted all test information from the tables and relinked the tables. Now I want to start using the tables for "real" information, but the autonumber starts from where I...

Thanks PH I was making it too hard. After you think about it, this makes sense. Thanks again

PH I tried the modified statement and it doesn't work. I am working with a link table and our Central Office has set the [Object_Code] up as a "text" field and they won't change that. Any other ideas?

I am writing a query that separates Cash, Expenses and Revenue in separate columns. Each of these has its own [Object_Code]for each [Amt_Posted]. The object codes I have been useing are: 100 - Cash 600 - Expenses 400 - Revenues (But I also have other Revenue codes - 401, 402, 403, 410, 411...

I am trying to get an Access Report resembling a Bank Statement. I had to developed two queries, 1-a balance of all transactions prior to the month the report is for, and, 2-a detailed list of all transactions that occured in the month the statement is for. THe report is sorted by the Clients...