Run one of 2 subqueries

[bfunkyf]

I have a list of accounts - some individual and some part of groups. If the
account is an individual account I want to run one subquery based on that one
account #; if the account is part of a group I run a different query that
gathers the records for all the accounts based on the group name. I can
query the account # to see if it is part of a group, but how do I call the
individual query passing the account # through and/or call the group query
passing the group name through?

 

[June7]

Use If Then, here is pseudocode of the concept:

strAccount = textboxAccountNumber
strGroup = group name, if any, code to test for group (DLookup could
probably work)
If Len(strGroup) > 0 Then
run this query using the variable strGroup
Else
run this query using the variable that holds the account number
End If

 

[bfunkyf]

This looks like a good way to go, but, excuse my ignorance, is this a macro,
a SQL Query, or something else? How do I translate "run this query using the
variable" into a valid command?