Formula quick fix, help please

  • Thread starter Thread starter Kaylen
  • Start date Start date
K

Kaylen

Can someone quickly help me fix this formula:
Expr1: "[Files]![1]=" & [Enter Service Type]

After I ran the query, I keep gettting: [Files]![1]=Post-Service

I want the field to show only what I enter as a service type in the
parameter. I want it to show only "Post-Service" not the [Files]![1] part.
When I ran the query, the query should ask me to enter the parameter: "Enter
Service Type". When I type "Post-Service" I just want the expr1 to show
"Post-Service" only. Can someone help me fix this formula? Thanks a bunch!!
 
Thank you soo much!

Mark A. Sam said:
Try, Expr1: [Enter Service Type]

God Bless,

Mark A. Sam

Kaylen said:
Can someone quickly help me fix this formula:
Expr1: "[Files]![1]=" & [Enter Service Type]

After I ran the query, I keep gettting: [Files]![1]=Post-Service

I want the field to show only what I enter as a service type in the
parameter. I want it to show only "Post-Service" not the [Files]![1] part.
When I ran the query, the query should ask me to enter the parameter:
"Enter
Service Type". When I type "Post-Service" I just want the expr1 to show
"Post-Service" only. Can someone help me fix this formula? Thanks a
bunch!!
Click to expand...
Click to expand...
 
Back
Top