Search results

I don't know how but it works, I started from scratch and same error, I started with a small sample of rows and it was OK, so I started enlarging the database and it works. Thanks for all the help.

EMP I get the following error when I transfer the queries to my database on Query1 Data type mismatch in criteria expression Is it something to do with Replace as it adds As type to the end of the first line.

I have been trying to develop the database and have come across a problem. I tried to introduce another type (debit memo) that would be treated like an invoice and thought that by adding this to the invoice query it would be counted in the extraction. It was but it threw up an anomaly in that...

Absolutely amazing, thanks very much EMP and Jon. I will spend some time working out how you have structured the queries to get the end result.

You are right EMP I have probably confused the issue by my use of unique, in my mind I have three types of account that I believe are unique in the database Invoices Only Credits Only Mixed invoices and Credits Extracting invoice only with multiple and single records per account Extracting...

I thought I was just getting the hang of the structure of the query criteria but trying to add further columns to the database wont work with the group by for me, is there away of adding to the output. I am also not sure it is working correctly as the output does not give any duplicate account...

Thanks Jon that worked really well, if I wanted a list of only mixed credits and invoices I suppose that If I can get a full list then take the take the credits out with WHERE Not type<>"Credit"; that would work? Is there a full list of expressions and their use so I could work some queries out.

Thanks again for your help Jon, I did say I was new to access, know I now the difference between query design view and sql view, I was trying to insert your string into the query design. One of the things that puzzles me is why the performance for this query should be so poor, it froze searching...

Thanks Jon, that pulls the first account number that meets the criteria, what has to be changed to extract other account numbers that meet the same criteria.

The database is an imported excel spreadsheet, all I did was determine the duplicate and unique records first by false for unique and true for duplicate. That way any unique record will have false attached to it.

I am new to access so I hope someone can point me in the right direction. I have a database that I need to query by account number and invoice type. Extracting unique single records is ok but I can not work out how extract multiple records. If the account number has several records(rows) and...