Recent content by paul25_uk

Hi, I know that it's possible to return the top 10 fields say in a query. Is it possible for a query to return the top 10 records for each location say? Each time the location changes, it returns the top 10? If anyone can help it would be much appreciated. :)

Thanks Superstar, Thanks a bunch, much appreciated :D

Additional Info Can you tell me why there is an additional ' surrounding some references? I'm very new to all this and it's probably that what has caused me to get this wrong. Any help/advice is well received! Thanks :D

Hi, i know there are loads of posts for this problem but no matter how many I read it just doesn't seem to work! Basically I have a form and i need to have a text box which shows a value of business placed into a specific hotel by a specific client. The table where that data comes from is...

All done :D Sorted now, just placed Like "*"& then my iif statement then &"*" and now it works like a treat. 3 Questions, 3 answers in 2 days. Really appreciate all the help, great bunch of people for a first timer to a forum! :)

I have a Problem! I have Created a query which runs when data inputted from a form is entered. The Query ([HotelForm] references a couple of Option Groups on the form[Hotels] and based on which is active it returns the data in Txt_Search into the Query Criteria. The problem I have is when...

All done! Happy! All done, found an older post I understood! :D

Thanks Tell me.... Should i feel this stupid? :(

Ok...second post ever, this is driving me mad! I have a form [Reviews], with one option group[grp_Location] containing 4 options, All (1), Premier House (2), Crookesmoor (3) and Woodbourn (4). I have a query setup that populates the subform. This works for three options, 2,3 &4 however I...

Hi, first ever post onto the site so please be gentle! I'm new to programming and have really no idea, however I am trying to learn as I go. I have an idea and i hope that someone can help me out. I have a form called [Reviews] and this has been setup with a few simple unbound tex boxes to...