Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Criteria to use to dump it excel
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel should remember sort criteria | Excel Worksheet Functions | |||
Click on Excel Doc Starts Excel but Excel does not Open the Doc. | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
how to use lookup a value by date for criteria in Excel sheet | Excel Worksheet Functions |