Search results for query: *

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...

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...