Search results

Is it possible to create a look up list for a field, in which the list displayed will depend upon the contents of the previous cell? EG. I have an 'Area' field (the contents of which is selected from a drop down box). If Communication were selected from this list I need the drop down for the...

The system is already in place and I cannot change the table structure. ... The query I have done is looking for records where the SickStart and SickEnd are both >[Enter start date] And <[Enter end date]. Which will obviously exclude records with dates outside of these. If I do a varity of...

I totally agree that that would be best Ken, but unfortunately I do not have the option open to me to change the design.

mon-fri only counted as absence

I need to stick to the same format if at all pos. Could it be done something like this: If [Enter start date]>=SickStart and [Enter end date]<=SickEnd then AbsentDays = ([Enter end date]-[Enter start date]) else if [Enter start date]>=SickStart and [Enter end date]>=SickEnd then AbsentDays =...

But couldn't you end up with hundreds of records for a member of staff on long term sick leave?

oh right, lets make it forename and surname then...

I already did, it doesn't have anything like this from what I can see. Thanks anyway. Any other ideas?

I am sure this isn't terribly complicated, but I can't even think where to start at the minute! Basically I have a database which consists of two tables. One with data about employees and another which may have several related rows about an employees absence. Below are the fields in each...