10981000

 

the user is only familiar with the last six digits

 

my formula is

 

{Employee_job_History_SCD.Client_ID} = {?Client ID}

 

How to I get the ability to append the digits 10 to a six character entry of 981000 in the parameter

 

field is client_id(PK,Int, not null)

 

Parameter is a number

 

Produces no results

 

Am trying to allow the user to enter 981000

and append this with a 10 to get 10981000 that can be used to look up the value 10981000 in table

 

Not having any success

 

Any furthur thoughts would be appreciated

I would not assume that the fomrula is the issue and try first to just enter the data straight up to test and make sure that part is working.

enter

10981000 intot he run time param

and in the select statement use

{?Client ID} = {Employee_job_History_SCD.Client_ID}

Did you get the record you expected?

in the select expert try

{Employee_job_History_SCD.Client_ID} = 10981000

Does that work? if not you have a bigger issue

try

{?Client ID} = {Employee_job_History_SCD.Client_ID} but enter 10981000 as the param. does that work?