MarkAndrews
Well-known Member
- Joined
- May 2, 2006
- Messages
- 1,970
- Office Version
- 2010
- Platform
- Windows
Guys, I really need an answer to this
I have a large dump of data which i am extracting by month onto seperate sheet tabs (Jan - Aug)
When selecting all the data, it wont copy over certain dates (specifically in the 'AbortDate' column)
Any idea's? TIA
I have a large dump of data which i am extracting by month onto seperate sheet tabs (Jan - Aug)
When selecting all the data, it wont copy over certain dates (specifically in the 'AbortDate' column)
Any idea's? TIA
Code:
SELECT `Data$`.ClientID, `Data$`.IntroducerID, `Data$`.MatterID, `Data$`.StartDate, `Data$`.AbortDate, `Data$`.AuthActDate
FROM `\\hqnas01p\redirect$\mandrews\Desktop\Abort Data`.`Data$` `Data$`
WHERE (`Data$`.StartDate Between ? And ?)