Query Criteria

[kev88]

Hi there,

I have been requested to complete a query where only records which are above the "net value" entered by the user are displayed. For example, if I entered £100 into the database, it would display records of £100 and over and not records that have a "net value" of £50.

Screenshot:

i52.tinypic . com / 10iazkh.jpg

What should I include in the criteria to allow this to happen? Do I need criteria in the 2nd column? (e.g. only displays net values greater than the entered amount in 1st column?)

 

[vbaInet]

After Update event of the textbox where you enter the amount

If Len(Me.[COLOR=Red]txtboxName[/COLOR] & vbNullString) <> 0 Then
     Me.Filter = "[[COLOR=Red]AmountField[/COLOR]] >= " & Me.[COLOR=Red]txtboxName[/COLOR]
     Me.FilterOn = True
End If

Amend the bits in red.

This is for a form of course.

If it's a paramterised query, then the criteria will be:

>= [Enter Amount]

 

[kev88]

I have added this but when I run the query, nothing comes up?

i52. tinypic. com /11rqcfo.jpg

what have I done wrong? Sorry Im not too experienced with Access.

 

[vbaInet]

When you enter a value, you have to move the cursor to another control for the code to run.

 

[kev88]

Sorry what do you mean by that? I have very limited experience with Access

 

[vbaInet]

Is this a query or a form?

 

[kev88]

this is a query

 

[vbaInet]

You should find what you're looking for in the link below:

http://office.microsoft.com/en-us/access-help/introduction-to-queries-HA010209892.aspx

 

[kev88]

thanks for the link

i had a look and i cant find anything about this specific problem I have about displaying data that is over the entered value?

 

[vbaInet]

You should be able to come up with something from reading the section "Ask variations of a question by using parameters with a query" and from what I showed you here -->

If it's a paramterised query, then the criteria will be:

>= [Enter Amount]