set of dates excluding specific dates

  • Thread starter Thread starter BB
  • Start date Start date
B

BB

I don't know what operators to use, obviously. I am
trying to run a query that includes between 5/1/04 and
6/18/04, excluding every Friday. Help please.

Thank you.
 
Try this:

Enter this in a blank field of your query:
ExcludeDate:WeekDay([NameOfDateField])

Enter the following for the criteria of the Date field:
Between #5/1/04# And #6/18/04#

Enter the following for the criteria of the ExcludeDate field:
Not vbFriday
 
Thank you.
-----Original Message-----
Try this:

Enter this in a blank field of your query:
ExcludeDate:WeekDay([NameOfDateField])

Enter the following for the criteria of the Date field:
Between #5/1/04# And #6/18/04#

Enter the following for the criteria of the ExcludeDate field:
Not vbFriday


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


I don't know what operators to use, obviously. I am
trying to run a query that includes between 5/1/04 and
6/18/04, excluding every Friday. Help please.

Thank you.
Click to expand...


.
Click to expand...
 
Jamie,

Look at the WeekDay function in the Help file. vbFriday is a built in Access
constant (I believe it = 6 for the sixth day of the week).
 
...
Look at the WeekDay function in the Help file. vbFriday is a built in Access
constant (I believe it = 6 for the sixth day of the week).
Click to expand...

I don't have MS Access! But I do have Jet and MDAC which I use from
Excel (you advertize as being my Resource For Help With Excel too
<g>). Are you saying that a query that uses this function cannot be
expressed in Jet SQL?

Thanks again,
Jamie.

--
 
(e-mail address removed) (Jamie Collins) wrote ...
"PC Datasheet" wrote ...
Click to expand...
I don't have MS Access! But I do have Jet and MDAC which I use from
Excel (you advertize as being my Resource For Help With Excel too
<g>). Are you saying that a query that uses this function cannot be
expressed in Jet SQL?

Thanks again,
Jamie.
Click to expand...

Ping 'PC Datasheet'?

Jamie.

--
 
Back
Top