Good example, Adam. The answer is YES.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Apr 1, 2015, at 7:07 PM, runuphillracing@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
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: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar