Search results

ICTKirsten watch this simple tutorial on YouTube on how to create a composite key/unique index for the prevention of double bookings. I personally didn't add the fields to my primary key index but made one called NoDuplicates. youtube.com/watch?v=uKwLIvV_S9Q[/url] - Please copy and paste...

Thank you. I like the second one, that will go into my very limited and basic toolbox of Access techniques. Your time is sincerely appreciated. I'd like to add that when I was switching about with the above criteria, I realised that the date of birth field that I have put my criteria in is...

My update query updates a currency field by subtracting £5.00. The criteria is based on a customer's date of birth field, and I use: <#31/12/1950# I have also tried YY/MM/DD. Basically, it works, but if a customer has a DOB on any date/month in 1950, it wont, and that makes no sense...

I'm a relative beginner in Access and studying an A level course like yourself. To solve the double bookings problem on my Hair Salon database (tutor defined the project, not me), I simply created what I understand to be a composite key and added to a new index in my appointments table the...

That is very skillful. Just for my own education - in the "Date Stopped" Column you will have created, do you mind breaking down this bit of code: +IIf(IsNull([AmountDays]),0,[AmountDays]) Thanks. :)

Sorry to waste anyone's time! I am a complete beginner in access... so leaving possible SQL statements behind, considering I thought that SQL was the only solution, I have worked it out! I just made another query, relevant to the criteria I needed, then put that query and the relevant table in...

Hi, Could any Access experts let me know if this is possible, and how it would be achieved: 1. I have an update query. 2. It updates the costs of treatments by a reduction of £5.00 (criteria is in DOB field <=#01/01/1950#) 3. I have a field that says: "Discount Applied?" - My...