Query if price is not null

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

i have a contiuios form that shows a list of products a comapny sells
it is based ona query at the moment

IT shows the following
ProductID
ProductName
RetailPrice
TradePrice

Not all products have a trade price, on the form i want a tick box or
somthing that i can click and it will then remove all the products in
the query that do not have a TradePrice

CAn any one ponit me in the right directions

Thanks
 
Use a button or checkbox and 2 separate queries as the recordsource for the
form. You'll need to put the button or checkbox in the form's header, then
use some code like:

If Me.Checkbox = True Then
Me.Recordsource = "Query1"
Else
Me.Recordsource = "Query2"
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query to show latest price based on dates 2
Query to show latest price 2
insert info into a table 2
Query Completion 1
Union Query 2
combo 1
Product Query Seach tool 1
Show all rows for one side of a many-to-many 2

Back
Top