Recent content by MrTickle

Thank you Bob and John, this has sorted it. I concatenated at query level and sorted at report stage and all is looking great. Thanks again!

Hi there Hopefully this is a very simple question. I have a text box in a report bound by datasource as follows: =[Guest Firstname] & " " & [Guest Lastname] I want the results to be ordered by [Guest Lastname], but I am not sure of the syntax when using 'OrderBy' and nothing I have tried...

Hi jkl0, that did the trick, thank you very much!

Hi I have a form with an unbound text box for the user to insert a date that will filter all records with this date, but it is not working. The code is based on someone else's code used for a similar function which does work, I just need to make it work in this instance and cannot for the...

Thank you so much, this works a treat! Andy

Hi there I have a database that takes accommodation bookings. I have a form for bookings that adds details to the 'bookings' table and a sub-form for reservations within that booking that adds records to the 'Room Reservations' table. For every booking there is a finite number of rooms...

Thanks for the reply. I have other tables too, very similar to the model you show here, but that will be useful for comparison. I only refer to the 2 tables in this thread because it is the specific issue I am trying to resolve. If anyone can offer any further guidance I'd be very grateful.

Hi I am developing a database for booking hotels for individuals and groups. I have come up against a problem for part of it. I have 2 tables; 'Bookings' and 'Reservations' 'Bookings' holds information about the client, the hotel they are booking, arrival date and number of rooms booked...

Hi All I am an expert user of databases but I am a novice builder and programmer! I've used loads over the years for various jobs, but I have no experience in building a complex database and zero knowledge in VBA or anything else useful. I've begun a project to build a database that manages...