Search results

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. :)

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...

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...

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...