H
Hanif Merali
Hello,
I'm having some trouble writing a parameter query. I have two tables
an Owners table with a bunch of fields one of them being ID (primary
key, autonumber), then there is a NationalAccounts table that has a
bunch of information in it ID field Name field, etc. There is a field
called Owner which is a # field referring to the Owners table. I wish
to run a query that takes in a National Account (Name field) and spits
out all other National Accounts with the same owner, so technically
this would be show all duplicates of NationalAccounts table tha thave
the same Owner field value as the parameter passed. I'm not sure
whats the best way to do this. I have never written a subquery but
perhaps this is this best way? Could I use a combo box which displays
a few fields from the national accounts table (ID, NAME, OWNER) then
hide the ID and OWNER field and assign the bounded column to 3 and use
that as a parameter? I'm not sure if this will work but this seems to
easiest way. Any advice would be greatly appreciated. Thanks
inadvance.
Regards,
Hanif Merali
I'm having some trouble writing a parameter query. I have two tables
an Owners table with a bunch of fields one of them being ID (primary
key, autonumber), then there is a NationalAccounts table that has a
bunch of information in it ID field Name field, etc. There is a field
called Owner which is a # field referring to the Owners table. I wish
to run a query that takes in a National Account (Name field) and spits
out all other National Accounts with the same owner, so technically
this would be show all duplicates of NationalAccounts table tha thave
the same Owner field value as the parameter passed. I'm not sure
whats the best way to do this. I have never written a subquery but
perhaps this is this best way? Could I use a combo box which displays
a few fields from the national accounts table (ID, NAME, OWNER) then
hide the ID and OWNER field and assign the bounded column to 3 and use
that as a parameter? I'm not sure if this will work but this seems to
easiest way. Any advice would be greatly appreciated. Thanks
inadvance.
Regards,
Hanif Merali