[mso] Re: Access Parameter Query - Wildcard
- From: "Glenda Wells" <gwells@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Mon, 22 Sep 2003 10:09:08 -0400
I have a table of companies and a table of customers.
The relationship is many to many.
The customer ID is in both tables.
I want to know who shops a particular company.
There are about 5,000 companies and 50,0000 customers. =20
I thought a parameter query would work using wild-cards to narrow the
search to a few companies but that's not such a good idea, now that I've
had a few minutes to think about it.
I probably need to do some kind of lookup. I might want to know what
companies a particular customer chops or what company has which
customers.
I looked up AutoLookup Queries but that's predicated on a one to many
relationship. So now I'm back to square 1 with no clue...story of my
life...and I was thinking this was going to be a quick, get it done kind
of thing!
-----Original Message-----
From: Greg Chapman [mailto:greg@xxxxxxxxxxxxx]=20
Sent: Monday, September 22, 2003 9:49 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access Parameter Query - Wildcard
Are you referring to SELECT * FROM * kind of queries? A little more
reformed might be SELECT * FROM (table name). Howsabout givin' your
Query friends an example of one you're trying?<g>
Greg Chapman
http://www.mousetrax.com=20
"Counting in binary is as easy as 01, 10, 11!
With thinking this clear, is coding really a good idea?"
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx
> [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Glenda Wells
> Sent: Monday, September 22, 2003 9:41 AM
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Access Parameter Query - Wildcard
>=20
>=20
> Hi All.
> I have a $70 Access reference book of more than 1,300 pages and can't=20
> find how to use wild cards in a parameter query!
>=20
> *[parameter]* returns every record. putting asterisks in when the=20
> parameter runs returns nothing. This doorstop...er...book isn't=20
> helping.
>=20
> Advice appreciated. /g
>=20
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to=20
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will
also allow you to change your email settings to digest or vacation (no
mail). //www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions. Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
