Criteria to use to dump it excel

K

Krish

I am accessing a database using ODBC and dumping the data into Excel
spreadsheet using microsoft query. I have created a limiter in Microsoft
query to select Invoices for a specified date, that has sales dollars less
than $ 1000. However I would like to see all the Invoices for the specific
customer, if that criteria is met, because certain customers want separate
billings for different product lines. The customer might have bought for
more than $ 1000, but in multiple Invoices. How do I accomplish this?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting excel to PDF, single page converts to multiple HELP! 1
True or False 3
TRUE/FALSE 5
Using a form to input update query criteria 2
How to merge a excel data in a word file with page breaks 1
How can I use a formula to calculate a running sub-total in excel 2
vlookup 2 arguments 4
formula patterns with a gap of two 0

Top