John,
In response to "IMO, the only reason to use SQL in a Record Source is when you want the form or report to be built on something dynamic - built at Open time," would that include if you want the user to be able to filter the form on different criteria? In the case I'm thinking about, It's a ranked list of clients sorted by their revenue totals for all products; a sum query where Product is not part of the grouping (I don't think I can do this including Product in the query). However, if I want to just show and re-rank clients by a product, I would re-write the sql adding "WHERE Product = '" & "ABC" & "'"; removing that when I want to show all.
Adam
__._,_.___
Posted by: runuphillracing@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar