Excel Networkdays function in Access

[RichardMGreen]

Hi all

I need to replicate the Excel function Networkdays in Access.
I've come across some VBA code but I'd rather do it using queries if I can.

Is it possible to do this in a query or do I definitely need code?

 

[SydneyGeek]

Do you get the multiple popups in Access, or only when you call the query from Excel?

Denis

 

[RichardMGreen]

I'm only running the query in Access for now until I get everything moved over from the VBA version.

 

[SydneyGeek]

Is any one of the queries a Crosstab?

Denis

 

[RichardMGreen]

No, just normal select queries.

::edit::
I'm not sure what I've just done but it's working properly now.
It's also pulling straight through to Excel using my ADO connection.

Thanks for all the help.

 

[SydneyGeek]

You're welcome.

Denis

 

[Mudbutt]

I know this is kind of old now, but I'm having the same issue that Richard was having. However, I'm not as apt to SQL code in access, I'm used to just dealing with the objects. If i just want to dump the formula into one of the fields, how do i write it correctly?

I'm trying to find the difference between "Req#dlv#dt" & "Act Date" to reference the actual names.

 

[Joe4]

I know this is kind of old now, but I'm having the same issue that Richard was having. However, I'm not as apt to SQL code in access, I'm used to just dealing with the objects. If i just want to dump the formula into one of the fields, how do i write it correctly?

I'm trying to find the difference between "Req#dlv#dt" & "Act Date" to reference the actual names.

It looks like you re-posted this question here: http://www.mrexcel.com/forum/showthread.php?t=582956

So let's keep it to one thread and address it there (see our policy on double posting questions here, rule #9: http://www.mrexcel.com/forum/showthread.php?t=99490).