Search results
-
P
Return Top 10 Records per grouped field??
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. :) -
P
DLookup criteria
Thanks Superstar, Thanks a bunch, much appreciated :D -
P
DLookup criteria
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 -
P
DLookup criteria
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... -
P
Getting a Query to return data where form txtbox gives partial Info
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! :) -
P
Getting a Query to return data where form txtbox gives partial Info
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... -
P
Beginner needs help with Form Refresh
All done! Happy! All done, found an older post I understood! :D -
P
Query from a Form Group buttons! Help!
Thanks Tell me.... Should i feel this stupid? :( -
P
Query from a Form Group buttons! Help!
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... -
P
Beginner needs help with Form Refresh
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...