Sub form

[Porkchop]

I have a sub form in my form. The sub form displays pricing for my customers
based on customer number entered on form and run through "Load pricing
Query"



I want to only display active pricing (customers have many pricing values)
not all. Do I do this with a bit of code?



Thanks

Jeff

 

[Jeff Boyce]

What about the idea of further modifying your query to only display "active"
pricing?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Arvin Meyer [MVP]]

If you have a date field, and the last date is the active price, then you
can run an Aggregate (Totals) query with the Customer, Price, and Date. Use
the Sigma button in the query designer to turn your select query into a
totals query.

 

[Porkchop]

Jeff
I'm quite sure how to do that, could you give some direction?
Thanks
-Jeff

 

[Jeff Boyce]

It all starts with the data... and I don't have any idea how YOU determine
that a price is "active".

If you have a field you can look at to see if a record is "active", just add
that field to your query and put the selection criterion in.

If you don't have a field that you use to tell "active", how do you tell it?
(You'll need to tell Access how to do it.)

Regards

Jeff Boyce
Microsoft Office/Access MVP