Search results

All, I have an if statement using various controls that are found on my form. For example, I have three fields: Date, Call Ref, Logged by. I have button that checks those fields to see if they have been filled out or not, using the following code: If IsNull(Me.Date) Then lresponse =...

I have created a quick mock database to show you what I mean. Find it attached. Basically, I want to show any 3 hatchbacks or SUVs and any 2 saloons or motorbikes in the query. You can see currently it's showing everything.

Okay, In the query I have selected Top Values: 5. Which returns the top 5 values. Then, in an extra column of the query I have: Expr1: Rnd(Asc([Make])). This expression is sorted in an ascending format. ----------------------------------------------------------------------- For...

Hi all, I am trying to make a specific query work. I already have it returning the top 5 random values using a Rnd expression. Though, I wish to further enhance it by returning a certain amount of values, for example: 2 of anything in this list ("Honda","Toyota") 3 of anything in this list...

Hi all. I just wish to let you know my background first before I get into asking my questions. I started out with Access in 2009, and learnt in Office 2003. We were taught Access by creating a School database (Pupils, Tutors, Certificates, Modules). This was a part of my college course in...