Query that finds parts that start with * wildcard

[seat172]

I have a sales invoice table that contains parts that start with *, for example *SPR362.

I need to select only those parts that start with the *, as this is the wildcard in queries how do i select those products that start with it without it being recognised as the wildcard and selecting all records?

The field name is simply: Part



Many Thanks

 

[Dennisk]

access help says that in order to search for a wildcard enclose it in square brackets

 

[seat172]

Thanks

Tried that but it won't work, it thinks it's a parameter and asks for a value. I only want the records that start with this as others may contain it but they are not required.

Regards

 

[neileg]

I'd create a calculated field that tests the first character and filter the results. Something like
IIf(Left([PartNo],1)="*","Yes")

 

[seat172]

Result

Thanks for your help, did this:

Part no: IIf(Left([dbo_ILines]![Part],1)="*",[dbo_ILines]![Part])

This does the selection as you suggested, as I was after the invoice number for these parts I then put is not null in the selection criteria for the part to exclude the parts that do not start with the * .

Bingo, list of parts that start with * along with the invoice number I was after.

Many Thanks for your help