Search results

I hate you for being so good!! ;):p

Hi, I have an Iif statement running on a query that figures out based on time if someone has slept in at work... Sleep In: IIf([Time Out]>=#21:55:00#,"Sleep In","") I want to add to this that I only want it to run the above Iif statement if the [Notes] column is null. I still want all records...

Wow, You boys have been busy!! I have spent time learning the cascading combos and that has helped with other aspects of my database design so I thank you for that. Sure there are easier ways to do it but I'd prefer to better my knowledge so that in future I can design something based on...

I think the cascading combos is the way to go thanks for the info! I know what you mean guys about the obvious but the info I am putting in needs to match a database I am working on which has the options in. I don't want to destroy it for the basis of ease. Better to do it right from my end.

Its part of a form where if you choose no you then choose from the next column drop down. The country of birth column is a drop down to choose the country. If worker is born in uk and the value is yes i want that column to point to 826 or whatever. So if you choose no before you will have...

Hi, I am trying to add a value to a column in a query based on the value of another column. I am using an Iif statement for it but can't get it to work. I have a column called [Was Worker Born in UK] which has 3 options of "Yes, "No" and "Unknown". The next column is the [COUNTRYOFBIRTH]...

Hi, Thanks for the interest guys but I have sorted it. I just had a second table showing in a query window that didn't need to be there which was confusing the query. Thanks again, Paul

Hi, I have attached my database which has an append query in it. Basically if a training course has a renewal date another query tells it what date it should be rebooked. The last record of this is then appended to another table so that when a course is renewed it can be ticked off. The issue I...

Hi, I'm just wondering if this would be possible. I have a staff rota system that works on a rolling 4 weekly basis. I am using a table to store the shifts of a person dependent on week. I want to be able to tell access that Monday on week 1 corresponds to a certain date and then get access to...

Nice one pr2-Eugine, that has done what I wanted. Good work as always!!

Hi, Not sure on how that would work as there are a few variables eg. If the house = "AV" and its a Weekday and the Sleep In column is "Sleep In" then it should equal "V". If its a Weekend and the above it would equal "A". If the house = "LH" and its a Weekday and the Sleep In column is "Sleep...

Hey, I need a module but haven't got the foggiest on where to start. I have a query that works out whether a staff member has done a sleep in based on their clocking out time (TIME OUT). I also have a column for DAY IN which it stores the day they logged in and HOUSE which indicates which house...

Re: Add a new column in query that displays "Sleep In" if column A is greater than 9. Hi, Yeah I tried to do something like that but it just stopped the whole thing from working. I'm not very well up on modules. I'm a macro kind of guy! Cheers Paul

Add a new column in query that displays "Sleep In" if column A is greater than 9.55pm Hi all, I have a query I am building and I would like an extra column that shows "Sleep In" if the time out column is after 9.55pm and before 12am and by blank if before 9.55pm. I want to show all values but...

Absolutely perfect that! Thanks a lot!!

Hi, I am creating a timesheet database for work. We will be using TimeStation app which allows export of excel documents. I have linked the table with the same headings as the excel dosument and am importing the data based on that. What I want to be able to do is run a query that gives us...

Hi, Thanks for the reply. We have a very complex system and have tried some of the cloud based programmes out there but none of them meet our needs properly. What I am trying to achieve is having a 4 week template for each staff member which you would change if shifts changed (not sickness or...

Hi all, I'm trying to make a simple program to automate timesheet templates. Each of our staff members work on a 4 weekly basis (week 1, week 2, week 3 and week 4). I currently use a word document with the template in and copy and paste it into the timesheet. The timesheets run from the 23rd...

Nice one Pat. It took me a while to truly understand what you meant but then the penny dropped! I ended up habing to go through and change all the sql statements as they were working off the old queries that did not use the ID and only the name. Eventually got it working and now it is great...

I have finished a database with very little knowledge and just learnt as I have gone on via youtube etc. Trouble is the first thing I learnt was from someone who didn't know. I followed their instructions for using the lookup wizard and rather than point to the ID I pointed to the name. I only...