Make table query (I think)

[Jim W]

Having a bit of trouble here. I trying to calculate weekly total's.
The weekly totals would be down hrs for a given week so the value would be in hours. I think I sould also tell you that I'm running a split dbase with the backend installed on a server and about 20 frontend users. Now I not sure but I think I need to use and append query to update the table. Now the weeks are fixed and I have a table with 3 fields (Week Number, Start of Week. End of Week) an example would like this below
03 Week 35 , 9/1/2003 , 9/7/2003
03 Week 36 , 9/8/2003 , 9/14/2003
and so on until week 52 then it will restart with 04 Week 1
So the weekends every Sunday at Midnight. So now I have a table called weekly down hrs. How do I get (I think) an append query to run on its own every Sunday Night to add new records to this table?

Thank you for your time
Jim

 

[Travis]

If you are using a Pure MS Access approach then you will need to use a form with its timer event. Checking to see if it is just after Sunday midnight and that the record has not yet been created. However this will require that MS Access and this form be open.

Other methods are:

to use the Windows Task feature to run a database thats startup function is write the record and then exit.

create a VB application

create a Windows Service

Use a 3rd party product such as what FMS Inc. sells.


Use an SQL server as your backend and let the server do the work.


Another posibility is to not use a timer, but on the first person getting into the system create the necessary records as part of the Startup (AutoExecute) of the Access Application Database file.

 

[Jim W]

I would like to stay within access if possible. I do have a startup screen on the database but how would I go about seeing if the record has already been created?
I only want to create this record once a week?

Jim

 

[Travis]

There's DLookup or even opening a DAO or ADO recordset.