Search results for query: *

Thanks to the both of you! It is working with the last code from PHV - the other will probably work too now that there is a naming error!

I had made another query after count days but the data is the same and same format (columns).

This is the code that produced my table. The table above was only to provide a sample. The number of days in the closed & open aging are a result of a calculation from a begin date to either a closed date (or today's date if still open). The summary report is supposed to say that X of total...

Okay, I've pasted and modified the query to this: SELECT Region, Type, SUM(iif([PSU Data_TAT]![Closed Aging] BETWEEN 1 and 3, 1, 0)) As [Closed in 1-3], SUM(iif([PSU Data_TAT]![Closed Aging] BETWEEN 4 and 5, 1, 0)) As [Closed in 4-5], SUM(iif([PSU Data_TAT]![Closed Aging] BETWEEN 6 and 10, 1...

Sample Data (I would really like to be able to provide a report based on this data): Region Type Closed Aging Open Aging East UEC 2 0 East UEC 7 0 East UEC 1 0 East EUR 3 0 East EUR 31 East EUR 3...

I need to create a summary report detailing the # records closed within 1-3 days, 4-5 days, etc. and open for still open and their aging...sorted by type and region. I've tried several count queries but I am not getting accurate numbers. I've even created a query that if the data in the column...

I have billing addresses that come in all kinds of formats. Basically, I'm supposed to move anything that resembles a secondary address (such as suite, floor, #, room, etc.) to the secondary address column. I can do an expression for one criteria at a time (eg. suite only), but can it be done...

Awesome! Thank you for your help!

I am working on an Access 2000 database where I have to manipulate the data into a specific layout. I need an expresion (or something else) that will allow me to separate a suffix from a last name (I also have to do this with first name and middle initials, suites from addresses, etc.). I am...