| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Query & Pivot table?
I have created 2 pivot tables in an excel workbook.
1. The first pivot table brings in values from midnight to 6am. 2. The second pivot table brings in values from the previous 5 days. My question is how do i state the [Date] criteria in Microsoft Query to include the last 5 days but not today? Right now I have a field called [Date] and the criteria is set as; [=getdate()-5] this works, but i do not want today's values. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Query | Excel Discussion (Misc queries) | |||
| Pivot Table Query | Excel Discussion (Misc queries) | |||
| Creating Date Range in Pivot Microsoft Query | Excel Discussion (Misc queries) | |||
| Syntax Error - Using Microsoft Query and ODBC link to a table | Excel Discussion (Misc queries) | |||
| Using Microsoft Query data in a pivot table. | Charts and Charting in Excel | |||
Threaded Mode
