Help me make this query Excel friendly 1

[mkallover]

I'm trying to link Excel to several queries I have created in Access. Unfortunately Excel does not like a WorkingDays function that I created within an Access module so it won't import that query. Is there a way to do this query that will be more Excel friendly?

TRANSFORM Count(R.request_id) AS [Count]
SELECT R.request_subject_name
FROM qryCPOFirstResponse AS R
WHERE WorkingDays([prcs_add_tmsp],[Response]) < 1
GROUP BY R.request_subject_name
PIVOT Format(prcs_add_tmsp,"yyyy/mm");

 

[SkipVought]

Hi,

How are the WorkingDays function arguments defined?

What is the LOGIC that this function applys?

Give an example of VALUES of arguments given and the expected result.

Plase answer each of these questions fully.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

Please post the code for this UDF, from your VBA module.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[mkallover]

It's actually just this code:

http://www.mvps.org/access/datetime/date0006.htm

My wording made it sound like I created the code when I meant I created a module.

 

[SkipVought]

In your query from Excel, just return the dates you want to use for Start and End. Paste the function code into a Module in Excel VBA and use it on the sheet in an adjacent cell to your query results. The Data > Import Extrernal Data > Data Range Properties window has a CHECKBOX that will propogate your formula thru ALL ROWS of your returned data.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]