Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO From Excel 2003 to a access.mdb Query
Hello I have read i can run a query in access from excel but im not having
any luck This may not be were I in need to post this ? If its not can someone tell me where to post. The Where is my problem. The SQL below is a access query and I have a form to pick the between Receiving.RECEIVE_DATE. I would Like to use a form in Excel to pick the between Dates Can anyone help SELECT DISTINCTROW Receiving.RECEIVE_DATE, Receiving.INVOICE_NUMBER, Receiving.RPT_GROUP1, Receiving.DEPT_GRP, Sum(Receiving.COST) AS [Sum Of COST], Receiving.VENDOR_ID, Sys_Pram.STORE_NAME FROM Receiving, Sys_Pram WHERE (((Receiving.RECEIVE_DATE) Between [Forms]![frmDatePicker]![txtStartDate] And [Forms]![frmDatePicker]![txtEndDate]+1) GROUP BY Receiving.RECEIVE_DATE, Receiving.INVOICE_NUMBER, Receiving.RPT_GROUP1, Receiving.DEPT_GRP, Receiving.VENDOR_ID, Sys_Pram.STORE_NAME; |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 query from Access 2000 database | Excel Worksheet Functions | |||
importing/linking data from an Access 2003 Query to an Excel 2003 | Excel Discussion (Misc queries) | |||
MS Query - from Access 2003 to Excel 97 | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
How To Pull Access Query into Excel (2003): Reposting | Excel Programming |