Hello, I am hoping someone might assist me with a problem. I am trying to customize a customer report to show the Notes from the customer file. It has been suggested to me to run a query on this to pull the info I want. This is great, but not ideally what I am looking for. I want anyone in the office to be able to run the report and filter it to their specifications. For example: we have an anual catalogue and we do not send it to everyone on our mailing list. We want to send it to local customers who have spent money with us or who specifically request a catalogue. We have used up all of the custom text feilds for other info, so if we place a "note" in the customer file, "please mail catalogue" then run a report on customer notes feild and filter it to contain catalogue then we would have our list.
I know the Notes feild exists in the Customer Table, but when I try to add the feild to the report I get only an error message.
Any help would be appreciated. Thanks