Prompt in query

[Cissy]

Hi! Thanks for your help. I'm using Access XP.

I've created a query that needs to pull all client/matter numbers. The
numbers appear like this: 444444-444, client number being the first 6
digits, matter being the last 3. They are separated by a dash. I need to
query on the first six digits and then pull all numbers regardless of the
last three digits. So far I have:

[Enter Billing #]+"*"

When I enter "112261" I need to see "112261-888", "112261-983", "112261-341"
etc. in the results window. But it doesn 't work, I've tried it every which
way.

How do I write this piece of criteria? Thanks much.

 

[Rick B]

First, you should not store two pieces of data in one file. You should have
a client field and a matter field. You can DISPLAY them as you indicate on
forms, reports, and queries, but you should not be storing them that way.

If you do want to keep your current design, use the following.

=[Enter Billing #] & "*"

 

[Cissy]

Thanks Rick. I will take your advise and make the corrections. In the
meantime, I tried =[Enter Billing #] & "*" in the first criteria row in the
billing # field and it didn't work. What am I doing wrong?? thanks

First, you should not store two pieces of data in one file. You should have
a client field and a matter field. You can DISPLAY them as you indicate on
forms, reports, and queries, but you should not be storing them that way.

If you do want to keep your current design, use the following.

=[Enter Billing #] & "*"

--
Rick B

Hi! Thanks for your help. I'm using Access XP.

I've created a query that needs to pull all client/matter numbers. The
numbers appear like this: 444444-444, client number being the first 6
digits, matter being the last 3. They are separated by a dash. I need to
query on the first six digits and then pull all numbers regardless of the
last three digits. So far I have:

[Enter Billing #]+"*"

When I enter "112261" I need to see "112261-888", "112261-983", "112261-341"
etc. in the results window. But it doesn 't work, I've tried it every which
way.

How do I write this piece of criteria? Thanks much.

 

[Rick B]

Try:

Like [Enter Billing #] & "*"

That should work. This is a "text" field, right?


--
Rick B

Thanks Rick. I will take your advise and make the corrections. In the
meantime, I tried =[Enter Billing #] & "*" in the first criteria row in the
billing # field and it didn't work. What am I doing wrong?? thanks

First, you should not store two pieces of data in one file. You should have
a client field and a matter field. You can DISPLAY them as you indicate on
forms, reports, and queries, but you should not be storing them that way.

If you do want to keep your current design, use the following.

=[Enter Billing #] & "*"

--
Rick B

Hi! Thanks for your help. I'm using Access XP.

I've created a query that needs to pull all client/matter numbers. The
numbers appear like this: 444444-444, client number being the first 6
digits, matter being the last 3. They are separated by a dash. I need to
query on the first six digits and then pull all numbers regardless of the
last three digits. So far I have:

[Enter Billing #]+"*"

When I enter "112261" I need to see "112261-888", "112261-983", "112261-341"
etc. in the results window. But it doesn 't work, I've tried it every which
way.

How do I write this piece of criteria? Thanks much.

 

[Cissy]

Yes it is a text field and this worked like a charm. thanks much

Try:

Like [Enter Billing #] & "*"

That should work. This is a "text" field, right?


--
Rick B

Thanks Rick. I will take your advise and make the corrections. In the
meantime, I tried =[Enter Billing #] & "*" in the first criteria row in the
billing # field and it didn't work. What am I doing wrong?? thanks

First, you should not store two pieces of data in one file. You should have
a client field and a matter field. You can DISPLAY them as you indicate on
forms, reports, and queries, but you should not be storing them that way.

If you do want to keep your current design, use the following.

=[Enter Billing #] & "*"

--
Rick B



Hi! Thanks for your help. I'm using Access XP.

I've created a query that needs to pull all client/matter numbers. The
numbers appear like this: 444444-444, client number being the first 6
digits, matter being the last 3. They are separated by a dash. I need to
query on the first six digits and then pull all numbers regardless of the
last three digits. So far I have:

[Enter Billing #]+"*"

When I enter "112261" I need to see "112261-888", "112261-983",
"112261-341"
etc. in the results window. But it doesn 't work, I've tried it every
which
way.

How do I write this piece of criteria? Thanks much.