Recent content by Kluft

Thanks, guys, u were real helpful. I finally got it. It was a bit more complex than that..I had to make 2 queries and link them, though the idea was the same(I mean, what you've told me). Thanks again:D

Ok...I tried that..didn't work..it just kept counting me the records for invoices. The problem is that CustomerID and InvoiceNo. are fields in 2 different tables and there's one-to-many relationship between them. Thanks for your time.

Great! I finally figured it out..with your help, of course. Million thanks for your time and your help!!:D

The report is based on a table. The thing is this sorting is not actually related to the pages themselves, and I wouldn't have any problem with the sorting if it weren't for that requirement. It says there that the last group of names should be sorted alphabetically by the first name. There are...

I have a table that contains the fields CustomerID and InvoiceNo. Any of the customers can have one or more invoices. How can I create a query that shows all customers that have at least 2 invoices? I've already tried writing the expression with operators, but they only refer to a specific value...

The option for "Hide Duplicates" is set to NO(for all the fields in the report). Should it be set to "yes"? As for the sorting issue, I was trying to sort in ascending order the first 7 pages in the report by the last names, and the last page by the first name. My question would be how can I...

I'd appreciate it a lot if you could help me with these 2 problems: 1. I have a report that includes a first name and a last name for several customers. The problem is that I have to sort this report in an ascending order first by the last name and then, by the first name within the last name...