Search results

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 -...

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