Hopefully an easy question

  • Thread starter Thread starter Thomas
  • Start date Start date
T

Thomas

Hello,

I would think this should be an easy question, but I've
spent hours trying to figure this out, and I can't.
Obviously I'm pretty new to Access.

I have a table called "ContactMaster" and I want to
create a query that lets me search the a field
called "Carrier" and display the field along with some
others.

For example: ContactMaster contains the following:
Carrier NPA NXX

CellularTWO 555 123
CellularTWO 555 124
WirelessONE 555 125

I want the querie to pop up a box, let me type in Cell
and then display all of CellularTWO's entries(If there
was a CellularTHREE, it would also show those). If I was
to type in "Wire", it would pull up WirelessONE.

I would think this type of query was the most simple and
easiest to create, but I just don't get it, I guess.

Thanks for any help!
Thomas
 
Hi Thomas,

In your query, investigate the use of LIKE in your criteria.

[Carrier] like "Wire*"

will pick up all Carriers beginning with Wirexxxxxxx i.e. Wireless, Wiretap,
Wire One, etc.

[Carrier] like "*Wire*"

will pick up all Carriers having the word Wire anywhere in the field i.e.
FireWire, WireOne, McGwire, etc.

HTH,
Immanuel Sibero
 
Thanks for your reply, Immanuel. What I'd like to do tho,
is get a text box come up when I run the querie, that
will let me enter in the criteria... Like if I was
looking for any carrier starting with Wire, I would type
in Wire* and it would list them all.

Thanks again!
Thomas

-----Original Message-----
Hi Thomas,

In your query, investigate the use of LIKE in your criteria.

[Carrier] like "Wire*"

will pick up all Carriers beginning with Wirexxxxxxx i.e. Wireless, Wiretap,
Wire One, etc.

[Carrier] like "*Wire*"

will pick up all Carriers having the word Wire anywhere in the field i.e.
FireWire, WireOne, McGwire, etc.

HTH,
Immanuel Sibero



Hello,

I would think this should be an easy question, but I've
spent hours trying to figure this out, and I can't.
Obviously I'm pretty new to Access.

I have a table called "ContactMaster" and I want to
create a query that lets me search the a field
called "Carrier" and display the field along with some
others.

For example: ContactMaster contains the following:
Carrier NPA NXX

CellularTWO 555 123
CellularTWO 555 124
WirelessONE 555 125

I want the querie to pop up a box, let me type in Cell
and then display all of CellularTWO's entries(If there
was a CellularTHREE, it would also show those). If I was
to type in "Wire", it would pull up WirelessONE.

I would think this type of query was the most simple and
easiest to create, but I just don't get it, I guess.

Thanks for any help!
Thomas
Click to expand...


.
Click to expand...
 
Hi Thomas

In your query, in the criteria for Carrier:

Like [Enter Carrier: ]

This way the query will pop up a box asking you to specify the value. You
can respond with Wire* or *Wire*

HTH,
Immanuel Sibero



Thomas said:
Thanks for your reply, Immanuel. What I'd like to do tho,
is get a text box come up when I run the querie, that
will let me enter in the criteria... Like if I was
looking for any carrier starting with Wire, I would type
in Wire* and it would list them all.

Thanks again!
Thomas

-----Original Message-----
Hi Thomas,

In your query, investigate the use of LIKE in your criteria.

[Carrier] like "Wire*"

will pick up all Carriers beginning with Wirexxxxxxx i.e. Wireless, Wiretap,
Wire One, etc.

[Carrier] like "*Wire*"

will pick up all Carriers having the word Wire anywhere in the field i.e.
FireWire, WireOne, McGwire, etc.

HTH,
Immanuel Sibero



Hello,

I would think this should be an easy question, but I've
spent hours trying to figure this out, and I can't.
Obviously I'm pretty new to Access.

I have a table called "ContactMaster" and I want to
create a query that lets me search the a field
called "Carrier" and display the field along with some
others.

For example: ContactMaster contains the following:
Carrier NPA NXX

CellularTWO 555 123
CellularTWO 555 124
WirelessONE 555 125

I want the querie to pop up a box, let me type in Cell
and then display all of CellularTWO's entries(If there
was a CellularTHREE, it would also show those). If I was
to type in "Wire", it would pull up WirelessONE.

I would think this type of query was the most simple and
easiest to create, but I just don't get it, I guess.

Thanks for any help!
Thomas
Click to expand...


.
Click to expand...
Click to expand...
 
Thats exactly what I wanted... :-) thank you very much,
Immanuel!!

Thomas
-----Original Message-----

Hi Thomas

In your query, in the criteria for Carrier:

Like [Enter Carrier: ]

This way the query will pop up a box asking you to specify the value. You
can respond with Wire* or *Wire*

HTH,
Immanuel Sibero



Thanks for your reply, Immanuel. What I'd like to do tho,
is get a text box come up when I run the querie, that
will let me enter in the criteria... Like if I was
looking for any carrier starting with Wire, I would type
in Wire* and it would list them all.

Thanks again!
Thomas

-----Original Message-----
Hi Thomas,

In your query, investigate the use of LIKE in your criteria.

[Carrier] like "Wire*"

will pick up all Carriers beginning with Wirexxxxxxx i.e. Wireless, Wiretap,
Wire One, etc.

[Carrier] like "*Wire*"

will pick up all Carriers having the word Wire
Click to expand...
anywhere
in the field i.e.
FireWire, WireOne, McGwire, etc.

HTH,
Immanuel Sibero



"Thomas" <[email protected]> wrote
Click to expand...
in
message
Hello,

I would think this should be an easy question, but I've
spent hours trying to figure this out, and I can't.
Obviously I'm pretty new to Access.

I have a table called "ContactMaster" and I want to
create a query that lets me search the a field
called "Carrier" and display the field along with some
others.

For example: ContactMaster contains the following:
Carrier NPA NXX

CellularTWO 555 123
CellularTWO 555 124
WirelessONE 555 125

I want the querie to pop up a box, let me type in Cell
and then display all of CellularTWO's entries(If there
was a CellularTHREE, it would also show those). If I was
to type in "Wire", it would pull up WirelessONE.

I would think this type of query was the most simple and
easiest to create, but I just don't get it, I guess.

Thanks for any help!
Thomas



.
Click to expand...
Click to expand...


.
Click to expand...
 
You're welcome. Good luck.

Immanuel Sibero


Thomas said:
Thats exactly what I wanted... :-) thank you very much,
Immanuel!!

Thomas
-----Original Message-----

Hi Thomas

In your query, in the criteria for Carrier:

Like [Enter Carrier: ]

This way the query will pop up a box asking you to specify the value. You
can respond with Wire* or *Wire*

HTH,
Immanuel Sibero



Thanks for your reply, Immanuel. What I'd like to do tho,
is get a text box come up when I run the querie, that
will let me enter in the criteria... Like if I was
looking for any carrier starting with Wire, I would type
in Wire* and it would list them all.

Thanks again!
Thomas


-----Original Message-----
Hi Thomas,

In your query, investigate the use of LIKE in your
criteria.

[Carrier] like "Wire*"

will pick up all Carriers beginning with Wirexxxxxxx
i.e. Wireless, Wiretap,
Wire One, etc.

[Carrier] like "*Wire*"

will pick up all Carriers having the word Wire anywhere
in the field i.e.
FireWire, WireOne, McGwire, etc.

HTH,
Immanuel Sibero



message
Hello,

I would think this should be an easy question, but I've
spent hours trying to figure this out, and I can't.
Obviously I'm pretty new to Access.

I have a table called "ContactMaster" and I want to
create a query that lets me search the a field
called "Carrier" and display the field along with some
others.

For example: ContactMaster contains the following:
Carrier NPA NXX

CellularTWO 555 123
CellularTWO 555 124
WirelessONE 555 125

I want the querie to pop up a box, let me type in Cell
and then display all of CellularTWO's entries(If there
was a CellularTHREE, it would also show those). If I
was
to type in "Wire", it would pull up WirelessONE.

I would think this type of query was the most simple
and
easiest to create, but I just don't get it, I guess.

Thanks for any help!
Thomas



.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top