Hopefully an easy question

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
 
I

Immanuel Sibero

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
 
T

Thomas

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...
 
I

Immanuel Sibero

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...
 
T

Thomas

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...
 
I

Immanuel Sibero

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search by product & alsoshow other products purchased by same cust 2
How to set up relationship query for minerals database 2
I want to display only unique records 5
Need Help Counting 5
changing the Phone Number Input Mask to all for extensions 2
Comparing Tables 1
Easy query criteria question 3
Probably a simple question 3

Top