Recent content by Learning123

Thanks, I'll have a go at this one then :)

Yep, I have a query with: Date of Lesson Horse or Pony ID Time of Lesson Both Date and Horse/Pony ID are Parameter queries. I then have a Report (sorry, I don't think I was clear enough about this before), based on this query. In the 'group and sort' option on Access 2007 I selected 'with...

Hi, would this work on a Count field? I notice that the ones on the link you gave me are all V lookups - but I'm not sure what to put in the expression as there is no need to look anything up. I tried using conditional formatting on the count field, and selected "Field value is less than or...

Hi, I have a bookings database for horses. I have created a query with these fields: Date of lesson - parameter query. Time of lesson Horse or Pony ID The user will then look down the query to see if the horse is already booked for that time. If not, then they can go ahead and make the...

:confused: thanks for your help but i really don't know how to do that..i'm not much of a wiz at access :eek:

Hi, My database is a horse-riding booking database. I have a form of rider details, with a sub form of bookings. I want to create a query that is linked from this form. The subform has: Booking ID Rider ID Date of lesson Time of lesson Horse or Pony ID Instructor ID Ride Type Location Paid...

:) Thanks - sorry I wasn't being clear enough, I did understand that - but it's working now anyway...I made a mistake in the expression before. Thanks again!

Thanks - but I can't seem to get that to work - do I use this in the Date field, where the format is general (dd/mm/yyyy), or do I need to change something to make this work?

Hi, I am creating a bookings database. I need to stop people from making a booking on Mondays. Does anyone know how to make a validation rule stopping people from booking on Mondays in the Date field? I am thinking that I need to have a Day field, where the Weekday number (1,2,3, etc) is...