Wildcards

[stm8ter]

I have a report based on a querry looking for Purchase Order Number. This works just fine, enter CM020401 and history report lists all of the Purchase Orders for this praject. On larger projects the Purchase Order Number is modified (to track seperate phases of project) by changing th first 2 Characters ex CM020401 to
DE020401 & TE020401. I am trying to pull a history for all phases of project CM020401. I tried **020401 but it is not working. ##020401 no such luck. I am sure there must be a wild card for this, but just can not find it.

 

[Jon K]

The wildcard character for any single character is ?

so try:-

Like "??020401"

 

[stm8ter]

Thank You for your help. Unfortunatly that did not work. I had actualy tried all of the Wildcard Characters, however after your response I tried again as I might have misentered something. I tried ??020401 and "??020401" (Never quite sure when I see a post in quotes if they are to be used or just for emphasis) Neither provided results.

I have a simple Query Criteria [Enter Job Number] Do I need to expand this criteria to accept the Wild Card or would I be better off to create a seperate History Report to bring the full project together.

Currently I have changed the Job Number on larger projects to track phases, however it may be better to keep the original Job Number as CM020401 and then add a Project Phase Number such as PI020401. I would prefer not to do this as there are several existing projects set up using the original practice.

 

[Jon K]

To use the wildcard character in a parameter, you need to code it like this:

Like "??" & [Enter last 6 digits of Job Number]


When the input box pops up, enter 020401

 

[brpallet]

You can also enable the * if you use the Like parameter:

Like [Enter Job Number. Use * for partial entry]

Type *020401 and it will return all records with that sequence at the end. This eliminates the need to enter only the last 6. You could use the entire string or the last 5 or so on.