LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 25th 05, 03:22 PM posted to microsoft.public.excel.worksheet.functions
Posts: n/a
Default 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?


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel should remember sort criteria jimmy27298 Excel Worksheet Functions 2 September 30th 05 06:01 PM
Click on Excel Doc Starts Excel but Excel does not Open the Doc. Mark Excel Discussion (Misc queries) 3 August 24th 05 02:33 PM
VBA for Excel 2000 file is corrupt nkamp Excel Discussion (Misc queries) 0 May 26th 05 03:37 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM
how to use lookup a value by date for criteria in Excel sheet dom Excel Worksheet Functions 5 January 11th 05 04:22 AM

All times are GMT +1. The time now is 10:10 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017