filter help

[dkinley]

I would check the table of the case number to see what that data type is and format accordingly.

-dK

 

[awake2424]

report filter

I figured out the problem and thank you for ur helpful sugesstions and patience.

 

[Alc]

Good news.

What was it? you never know who else might be having the same issues.

 

[dkinley]

hehe ... what was the problem?

 

[awake2424]

report

If I have some text that I want to include on the filtered report:

Example:

Name (autofilled) is case # (autofilled)

This text needs to appear on ever filtered report and the autofilled criteria is matched by the case. So I would like for Access to auto-populate the designated fields based on the filtered results. Is this possible?

 

[awake2424]

report filter

The problem before with the filter was a comma was misplaced in the code... once that was corrected the filter ran through with no problem. I am sure all the other comments and suggestions were also reasons for the filter working. Thanks again.

 

[dkinley]

So ... your query works, the report opens but it doesn't have that perfect format zing to it in a report control?


If that is the case, create an unbound control on your report and for the Data Source of the control put in ...

= "Name " & [ColumnNamefromQuery] & " is case # " & [ColumnCasefromQuery] & "."

Note: Change inside the [] to the appropriate field names for the data you want to go in there.

-dK

 

[awake2424]

report filter

I have attached a screenshot of what I think you mean (please correct).

Is the Fill supposed to be a combo-box and where is data source control?