Partial field value

  • Thread starter Thread starter Corren
  • Start date Start date
C

Corren

Access 2003/WinXP
I have a QBF for my Music Database where I want to search knowing only a partial name of the Track.
My Query:
[Forms]![QBF_Form]![What track]
works only with complete name of the Track, or, if left empty, returns all records.I would like to be able to search for, say
"Street" and find and get all the occurrences of "On The Sunny Side of the Street" and other tracks containing the word "street".
Could someone help me with this, please?
Thank you.

Corren
 
Hi,
Try:
Like '*' & [Forms]![QBF_Form]![What track] & '*'

--
HTH
Dan Artuso, Access MVP


Access 2003/WinXP
I have a QBF for my Music Database where I want to search knowing only a partial name of the Track.
My Query:
[Forms]![QBF_Form]![What track]
works only with complete name of the Track, or, if left empty, returns all records.I would like to be able to search for, say
"Street" and find and get all the occurrences of "On The Sunny Side of the Street" and other tracks containing the word "street".
Could someone help me with this, please?
Thank you.

Corren
 
This was the fastest successful reply ever, in any NG.
Thank you very much.


Hi,
Try:
Like '*' & [Forms]![QBF_Form]![What track] & '*'

--
HTH
Dan Artuso, Access MVP


Access 2003/WinXP
I have a QBF for my Music Database where I want to search knowing only a partial name of the Track.
My Query:
[Forms]![QBF_Form]![What track]
works only with complete name of the Track, or, if left empty, returns all records.I would like to be able to search for, say
"Street" and find and get all the occurrences of "On The Sunny Side of the Street" and other tracks containing the word "street".
Could someone help me with this, please?
Thank you.

Corren
 
You're welcome, the time of your post just happened to coincide with my getting home
from work and getting into the newsgroups.
As the comedians say, timing is everything!!

--
HTH
Dan Artuso, Access MVP


This was the fastest successful reply ever, in any NG.
Thank you very much.


Hi,
Try:
Like '*' & [Forms]![QBF_Form]![What track] & '*'

--
HTH
Dan Artuso, Access MVP


Access 2003/WinXP
I have a QBF for my Music Database where I want to search knowing only a partial name of the Track.
My Query:
[Forms]![QBF_Form]![What track]
works only with complete name of the Track, or, if left empty, returns all records.I would like to be able to search for, say
"Street" and find and get all the occurrences of "On The Sunny Side of the Street" and other tracks containing the word "street".
Could someone help me with this, please?
Thank you.

Corren
 
Back
Top