Search results

Brian, ignore me, I made a mistake there. Thanks for your help! One thing though, I created a few calculated fields which uses the results of that expression to calculate the total days taken. I've been using DateDiff to do this (but had to add 1 to all the expressions as it doesn't include...

Brian, ignore me, I made a mistake there. Thanks for your help! One thing though, I created a few calculated fields which uses the results of that expression to calculate the total days taken. I've been using DateDiff to do this (but had to add 1 to all the expressions as it doesn't include...

Thanks for that Brian, I came up with some other scenarios e.g. startdate >weekbegin and > weekend I was wondering if there is anyway to define those dates in between the StartDate and EndDate? likewise for the dates between the WeekBegin and WeekEnd dates? In which case would I then just be...

hi all, been thinkin bout this, would really appreciate any feedback from the much wiser than me.......Would something like this work? An expression that would use BETWEEN...AND function? i'm not sure how to write it so that it does this: Return all records in the Holidays tbl where the days...

Hi all, I'm trying to create a query which will retrieve holidays for a specific week, so it would allows me to enter WeekDesc (e.g. week 1) and Line (e.g. Line 1) and then retrieve some information relating to holidays. I have gotten this far already. However, I've just realised however that...

Thanks for the reply, i've amended the tables so they have just one primary key, which is the unique identifying autonumber. the tables which have more than one key are linking tables between 2 other tables, should these be queries? or are they ok as they are now, i have created some queries...

Yes the Line field in Line table and the Shift field in Shift table are set to no duplicates,and yes there is data in it....Shall I allow duplicates? I'll get rid of the data now

Hi Ken, thanx for having a look. the bold font fields are all set as primary keys. The link between Line and Shift_Line should be a one to many from Line to Shift_Line, (I think), similarly with the Shift table

Dear All, Please see attached word document with a screenshot of my tables and their relationships. I'm trying to link from Table:Line,Field:Line to Table:Shift-Line and similarly with the shift table and access is not able to maintain referential integrity. Can anyone explain why? and...

cheers for that Col, but I'm not sure where that goes? is it entered as a validation rule in the field properties?

Hi all, I'm trying to set up a holiday register. In my holiday table i have the following fields HolidayID, PersonID, StartDate, EndDate. I would like to have a final field which auto-calculates the number of days taken between start and end date. I read somewhere this should be done in a query...

Looks good to me, cheers Wazz!

Hi All, A bit new to this, any help most appreciated. I'm trying to set up a table which will have multiple fields (a recordset? is that right, if so I don't know how to set one up in access). Its for a skill set which is utilised by specific lines in a production plant. Each line in the...