Recent content by SarahO

Thanks for explaining the difference between the append & update queries. This makes sense now. I'll give the SQL a go and let you know how it goes. Cheers SarahO

Hi, I am working on a scheduling database and have got stuck with what I thought would be a simple update or append query (It probably is very simple for non-newbies). I am trying to create an update query to update the "Cell_ID" field in tbl_ScheduledAssays with the "Cell_ID" field from...

Sorry for the delay in replying. This worked and the offending record has now gone. Thanks Sarah

Help! A very strange record has materialised in my database. Consisting of characters like these: ༏｀䳾䬲 No 00:00:00 佔㌳ 7744 00:00:00 00:00:00 N/AŸÞ 呌ㅏＲ㋾〰 Yes Yes No Yes 00:00:00 00:00:00 00:00:00 00:00:00 Yes Yes Yes 00:00:00 〶〹Ｓ叾䅔⁂佐䱏删乕丠塅⁔䅄⹙倠䕒䅐䭃匠呅唠⁐义佃剒 0 00:00:00 䍅䱔ｙ䓾...

If you have a customer footer - right click the footer, select properties and format and then on force New Page select "After section". If you dont have a customer footer have you set up the groupings on your report? Sarah

Thanks I will try both ideas. The database uses an excel macro to add some of the jobs where as others are added manually via forms. The excel macro may mean that several jobs are added at once. I'll have a go anyway. Cheers Sarah

Try the following - Not sure if this is what you want but this subtracts the ActualStartDate from the TrackingStartDate and will do it in "Working Days" i.e. it won't include weekends or because I have a tbl_Holidays it also does not include public holidays either. NumberOfWorkingDays...

I built the DB originally, however had it sent away for normalisation and then the 2 databases were reconciled. The database is to schedule jobs required and many of the jobs contain very similar information hence the requirement for a large PK. I assume I will have to try and work out a...

I wonder if anyone can help me. I have a table in my database which currently uses 9 fields to make up the primary key. I wanted to add a further 2 fields to this to make 11, however Access will only accept 10. Does anyone know any way around this please?

Thanks Peter - that works.

Thanks BAT17 & Reclusive Monkey you pointed me in the right direction. I obtained almost what I wanted - see below in italics I have used the SQL below to calculate the working days including the "DateApproved" and "DateReceived" and exclude weekends and holidays. However, how do you modify...

Jon, You were helping another programmer with this problem back in Jan 2005. I have found this really useful and wondered if you would be able to help me a bit further with this please. I have used your SQL above to calculate the working days including the "DateApproved" and "DateReceived"...

I am trying to get an Expression in a query to only count "Working Days". The expression is based on two date fields and is: ([ActualCompleteDate]-[ComponentArrivalDate]) and I want the answer to include only days from Monday to Friday that are actual "Working days" i.e. not bank holidays...