Report filtering issue

[Mick99]

Hi all, I am having a frustrating problem with a report filter I have been using for years. The filter works fine if the data is a number, but I am using it for text this time and it simply will not filter the report because I am unable to have the text display as per below. I need to be able to put a qutotation mark before and after the text so that the report filter will recognise and apply the filter appropriatley.



The report filter requires this [RA] = "MT"

and this is what I currently have [RA] = MT

This is what the code looks like -

DoCmd.OpenReport "Rpt AMR", acViewPreview, , "[RA] = " & RScoloumdetail(5)

I just need a quotation mark before and after RScoloumdetail(5)

This filter does not work


And this filter works


Cheers Mick

[June7]

Parameters for text fields need apostrophe delimiters. Dates use # character.

Try:

DoCmd.OpenReport "Rpt AMR", acViewPreview, , "[RA] = '" & RScoloumdetail(5) & "'"

What is RScoloumdetail(5)?

[Mick99]

Legend, works a treat. Thank you sooo much. RScoloumdetail(5) is the 6th Col in a query I call that loops through a series of records matching data from another table, the field in a text field that holds initials.

Cheers Mick