Filter problem on a repot

[Polarbilly]

I've created a basic report which contains a field created by using the expression


=[FabricBatch] & [Job Sequence]

I've also tried using a combi box to do the same job, but in both cases whilst the data appears and is correct - I cannot get the "FILTER" to recognises it
(thats the "funnel" symbol on the "sort and filter" menu.) It seems so simple, but to a beginner.....

thanks in anticipation of your help

[June7]

I just tested this idea and apparently can't use the Access sort/filter tools on fields constructed by expression. If you need to filter a report, send filter criteria when the report is opened. There are several ways to do this, depending on the structure of project and your knowledge.

How are you opening the report - manually from the Navigation pane or with code (VBA or macro)?

[Polarbilly]

Thanks for the response...My knowledge is fairly limited and I don't think that I will be into VBA for some time. Have a basic knowledge of Macros.

I'm opening the report from a Switchboard. It would be preferable if the criteria could be selected from a list/drop down menu....

thanks for your help

[June7]

Then code in the button click event to open report would reference the combobox. I use only VBA but macro can do this:

DoCmd.OpenReport "report name", , , "fieldname='" & Me.combobox name "'"

This assumes field is text datatype, if it is number then remove the apostrophe delimiters, if it is date then use # instead.

[Polarbilly]

Then code in the button click event to open report would reference the combobox. I use only VBA but macro can do this:

DoCmd.OpenReport "report name", , , "fieldname='" & Me.combobox name "'"

This assumes field is text datatype, if it is number then remove the apostrophe delimiters, if it is date then use # instead.

Sorry to take so long to reply, but been away - works very well