[thelist] Conditionals in Access

[Ed McCarroll]

I don't know about the SUM/IN interaction, but you could run the
IN query only once if you used it to build a string of member_id
values, and then embedded the string in both of the main queries.

e.g. if your IN query returns t.member_ids: 123, 175, 345, 987

then put this in your WHERE clause:

  "/123/175/345/987/" LIKE "*/" & u.user_id & "/*"

HTH,

  Ed

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Ed McCarroll                          MailTo:Ed at ComSimplicity.com
ComSimplicity                                      (310) 838-4330
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -