Search results

I am inputing records through a form that has a check box to identify members. In the table the check box shows checked for members and no check for non-members. I want to run a single query that will pull members or non-members based on input from the user. In the query now I have the table...

Done exaclty as you stated but still get the same result. To be thourough, my exact steps were: 1. Right click the report 2. Select 'Design View' 3. Click once on the unbound text box in the header of the report 4. Select "Property Sheet" from the toolbar 5. Click on the 'Control Source'...

Thanks for the reply statsman but that didn't work. The quotes " " aren't acutally in the formula, I added them to the post to show what I had entered. I tried removing the equal sign = and I still get #Name in the title. There is a date range prompt in the query the report is pulling from...

Hi all, This is my first post and I am a novice Access user. I am trying to get my report to ask for a title when it opens. I have an unbound text field in the header with "=[Enter the Header Title]" in the control source but it does not prompt when I open the report. In fact the title...