Filtering report on part of a test field

  • Thread starter Rick C via AccessMonster.com
  • Start date
R

Rick C via AccessMonster.com

Greetings all!

I have a table named “Foster homes” which tracks (strangely enough) foster
home data including a text field containing the foster home license number
(field name Lic#) in the format CFxxxxxxxxxxx where x is a number.

I have created a query-based report and would like to filter out all foster
homes with a license number beginning with “CF99.” Can any of you enlighten
me as to the correct syntax for the query entry?

Thanx – Rick in Farmington
 
G

Gijs Beukenoot

From Rick C via AccessMonster.com :
Greetings all!

I have a table named “Foster homes†which tracks (strangely enough) foster
home data including a text field containing the foster home license number
(field name Lic#) in the format CFxxxxxxxxxxx where x is a number.

I have created a query-based report and would like to filter out all foster
homes with a license number beginning with “CF99.†Can any of you enlighten
me as to the correct syntax for the query entry?

Thanx – Rick in Farmington
Click to expand...

Add this to your query's SQL statement
WHERE Left([Lic#],4) = "CF99"
 
Top