how do i use input parameters with criteria

E

EKV@VWR

I have a select query which is mainly made up of expressed columns based on
"IF" statements comparing the two table in the query then returning a value.
I have input paremeters based on a [Warehosue location], [Audit Start date]
and [Audit end date]. In which I have identifeid what to return in the event
any of these are null. This gives me eight rows of input parameter criteria.
Now I want to add criteria in one column to be >0. This column summates all
the other "IF" statement columns. Is there an easy way to do this? I am using
Access 2007.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Parameter Crosstab query filter by form 1
query to show where no data in a stated column 0
Page numbering with Merged Document and IF statements 1
Can I save a sql statement generated by a search form? 1
eliminating criteria in a query 4
Parameter Query to filter dates as entered in and if not to show N 4
Need Help with a VBA subroutine 0
crosstab query with datea parameters 2

Top