Date without weekends inclusive

In Access2000,

I am trying to create a query that gives the number of orders received within a select period of time not inclusive of weekends. Can someone tell me how to do this in a query?

you can't do it in a query...You would have to write code that would determine if the day was a sat. or sun.

Gary

first you would have to determine if orders are really being placed into your system on a weekend (outisde of a automated ordering system this typically wouldn't happen) If they aren't placed on the weekend then is doesn't matter. The number of orders placed would only be for the weekday.

If you do have orders placed on the weekend and you want to see how many are placed on the weekday. Then I would writw a query that would look at the data of the order, Identify which day of the week that date is for(Weekday Function). If weekday is <> to 1 or 7 then I would place a 1 in a new query field otherwise place a 0 in the new query field.

I would then take a new query and and sum up the new query field and that would give you you total orders received during the a selected timeframs without including those recieved on the weekend.

You could possible even combine these two queries into one, but you would have to play with it.

Good Luck

S-