Then put a textbox in your report with this as the data source: =dcount("*", "Accepts")ĭone, and the nice part is it's not dependent on where it is in the report - you can put it anywhere. So in my case we'd write this query, called "Accepts": select distinct t.idįrom table t inner join response r on t.response = r.id EDIT: I've figured this one out: write a select distinct query with the criteria you're looking for.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |