Working Days and loops

Resolved · High Priority · Version 2003

Wed 1 Apr 2009, 16:29 Delegate David said...

David has attended:
Access Advanced course

Working Days and loops

Hi

I have been assigned the task of writing in access a rota for the judges in our court. They work on a weekly or 2 weekly pattern and they dont work weekends or bank holidays. I have setup a table with all the dates in for 2009 and all the different court locations. What I am having trouble visualising is how to create some sort of loop to enter in the database where the judge will be. For example I have a Judge (Smith) who sits Mon-Thurs in Gloucester and Friday in Cheltenham. What i want to do is populate my database with his name against the dates that correspond to Mon-Thurs for Gloucester court column and then Friday's against Cheltenham court column?

Any help would be appreciated.

Regards
Dave

Thu 9 Apr 2009, 10:43 Edited on Thu 9 Apr 2009, 10:44 Trainer Jacob said...

RE: Working Days and loops

Hi Dave

Interesting request, thanks!

Two ways to assist in you achieving your rota goal.

1) Attend our 2 day Access VBA course, the topics you learn will equip you with the tools needed to complete your objective.
more information on the course
click here

2) Consultancy, we can either train and develop the solution for you, or complete and hand back to you for testing, but to do so is beyond the scope of a quick 5 - 10 minutes via this forum.

If you can send us a copy/ captured screenshots of your database we will then be able to look at the structure of your database and how best to achieve your rota objective.

We may well find that this will take some trainer time to complete and therefore may incur a cost, but we will let you know anyway.

If you are interested to pursue either path, please let us know.

Regards

Jacob

Thu 16 Apr 2009: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips