Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / May 2005

Tip: Looking for answers? Try searching our database.

Choosing working days

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Luis - 29 Apr 2005 13:24 GMT
Hello.
I have a table that stores information as follows:

Field1            Field2               Field3
a1             01/01/2005             3
a1             02/01/2005             8
...                    ...                    ...
a1             07/01/2005             5
a2             03/02/2005             6
...                  ...                      ...
What i need to do is to create another table with just one line for a1, a2,
etc, that stores the sum of field3 but only for working days starting from
the first date that appears for each record. For instance, for record a1 i
want the sum of field3 of 5 occurences but excluding Weekend days.

Is this possible?

Thanks
Alex Dybenko - 29 Apr 2005 18:47 GMT
You can make a query which will group by Field1, sum Field3 and filter by
Field2 - here you can use datepart function to filter out sunday and
saturday.
also look at this page:
http://www.mvps.org/access/datetime/date0012.htm

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

> Hello.
> I have a table that stores information as follows:
[quoted text clipped - 15 lines]
>
> Thanks
Luis - 02 May 2005 13:55 GMT
Thanks Alex, but now i have another question:
How can i make datepart function to return which week day Field2 represents?

> You can make a query which will group by Field1, sum Field3 and filter by
> Field2 - here you can use datepart function to filter out sunday and
[quoted text clipped - 21 lines]
> >
> > Thanks
Alex Dybenko - 02 May 2005 16:45 GMT
type DatePart("w",Field2) is a query, and it will return weekday of Field2.

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

> Thanks Alex, but now i have another question:
> How can i make datepart function to return which week day Field2
[quoted text clipped - 27 lines]
>> >
>> > Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.