Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DSUM to pull data from Access DB
Howdy All,
I'm trying to sum data contained in an Access DB based on multiple criteria. DB name = FTD.mdb location = c:\FTD.mdb I'm trying to sum Labor hours (which are in a column labels 'Labor) for a specific 'Manager' (column name) and specific 'Assignee' (column name). Criteria entered in A1:B2 A B 1 Manager Assignee 2 Flintsone, Fred Rubble, Barney Formula I have tried =DSUM("C:\FTD.mdb","Labor",A1:B2) I'm getting the generic "The formula you typed contains an error." and it highlights my criteria range. Have I overlooked something simple (which I usually do)? Thanks, Brian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Applying Criteria in Excel Cell to MS Query Pull from Access | Excel Discussion (Misc queries) | |||
Can not access small cross to pull-down data | Excel Worksheet Functions | |||
Can excel pull data out of access? | Setting up and Configuration of Excel | |||
DSUM not pulling the data - why | New Users to Excel | |||
Pull down cell to access n&a spreadsheet | Excel Worksheet Functions |