Recent content by dcman

Thanks JHB that did it. I recreated Expr1 and used the string you provided. It now works... Thanks for your advice

My reason for not doing it there is that I have 2 variables to filter in the query and my Expr1 is just a text variable on the calling form and is not part of any database. My report works fine, the only thing it prompts me for Expr1 or should I say Cnum everytime. Thanks for your reply

My problem is this: I have a for form with a button to run a report. The report runs a query. The query reads data on the form to feed the report. The data that is from the table works fine but data from a text box on the form will not. It prompts for EXPR1. In my query I have the following...

Hi I am new to access and I have create a system for a non profit org. I have 3 tables invoice, customer and items. I need to create a query that will get the next invoice number from the invoice table and mark that invoice number in the items table for a set customer where the invoice field...