Recent content by jw1234

Terrible title for this thread but can't think of how to say it. Am working on my first true access db and need help to do the following task: I have two combo boxes sourced from one table (alldata). One is for Year where I have five years listed. One is for weeks where I have the weeks 1 -...

Thanks Thanks for your help, appreciate it!!

Get an error please help again I get an error which states The expression you have entered has an invalid . (dot) or ! operator or invalid parentheses. You may have entered an invalid identifier or parentheses following the NULL constant Are you able to give more advice. Thanks for your help

I have two fields in a query, [Stock] and [Minimum_Stock]. I want a new field called "Order", that displays a "Y" if the Stock field is equal to or less than the Minimum Stock Field. Can you please explain how I set this up inside me query. Thanks