| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
limit records in query
I see what you're saying...you can limit the records in the options, but
they don't follow through to the spreadsheet, only to the GUI. However you could add your own Top keyword to the SQL. That seems to work. -- Tim Zych SF, CA "dsharbaugh" wrote in message ... I am using query in excel to pull in data from an Access database. I only want 20 results, but the option in xls query is not working when I tick it and select only 20 records to be included. I don't want to limit the records in Access as the source there is used by other xls queries. Is there something else I have to do to make the xls query return only 20 records? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| QUERY FOR TODAY RECORDS | Excel Worksheet Functions | |||
| Keep cell data with records from a query | Excel Discussion (Misc queries) | |||
| Keeping cell data with records from a query | Excel Discussion (Misc queries) | |||
| Limit of records when using auto filter | Excel Discussion (Misc queries) | |||
| Limit trend line to last 12 records | Charts and Charting in Excel | |||
Hybrid Mode
