You are making this out to be more complicated than it is. I know what you are saying, basically, I'm just being lazy and don't want to install a particular script into a 100 computers, because of the level of permissions that we got set in the computers, it would take me a long time to do...
. Where will the script be located, the source for the copy operation? On a network share?
the logon script folder - C:\WINDOWS\SYSTEM32\GroupPolicy\User\Scripts\Logon
. Is this a Workgroup or Domain?
What does it matter? is a...
On the systems properties, go to the advanced tab, click startup and recovery settings and make sure both OS are listed. If not, you might have to edit the start up.
I have to sum every year, a year is 12 months from the initial month.
SO, if you signup on feb, then your year goes from feb.2003 to jan2004.
and there is a total needed for every year.
I know, is pretty frustating to not format this database to something better, but i'm stuck with it. [3eyes]
Thanks for the switch command, I think this is what i was looking for, will implement and see what happens.
To answer your question, it goes Jan-Dec, I used Jan-Mar as an example, I...
Let me modified the question, I need to know how to code in access (module, macro, whatever) so i can access the table. so my real question is how do i access the tables and write the respond based on a loop that goes through all the records based on the month of first sign on and totals.
If...
Every year it renews so:
Jan 2003: 0
Feb 2003: 50
Mar 2003: 0
Jan 2004: 0
Feb 2004: 20
Mar 2004: 50
Jan 2005: 10
Feb 2005: 10
Mar 2005: 20
Init$: 100
InitialMonth: Feb
Total2003 = 100 - 50
Total2004 = 100 - 60
Total 2005 = 100 - 50
Plus every consultant renews...
I have an MS Access Database. It has two tables.
Sample Tables:
tbl_Consulting_$sUsed
Fields:
Consultant Name: xyz consultant
Jan 2003: 0
Feb 2003: 50
Mar 2003: 0
Jan 2004: 0
Feb 2004: 20
Mar 2004: 50
Jan 2005: 0
Feb 2005: 10
Mar 2005: 20...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.