K
KB
In my database with columns (among others) "Date" and "Status", I have
information I need to pull up primarily by date. In the Date column, I
entered "Enter a start/ end date" criteria, and it only pulls up that
information just fine. My problem is now that those dates are up, I now only
want to show those files that are labelled "pending" in the status column. I
tried to enter pending in the criteria area, and access doesnt know which
criteria to sort as primary, so it lists all "pending" jobs, regardless of
date criteria. How do I sort first by date, then by status based on the dates
entered?
I did get a resoponse to post my sql, I was hoping for a more specific answer.
Thanks!
information I need to pull up primarily by date. In the Date column, I
entered "Enter a start/ end date" criteria, and it only pulls up that
information just fine. My problem is now that those dates are up, I now only
want to show those files that are labelled "pending" in the status column. I
tried to enter pending in the criteria area, and access doesnt know which
criteria to sort as primary, so it lists all "pending" jobs, regardless of
date criteria. How do I sort first by date, then by status based on the dates
entered?
I did get a resoponse to post my sql, I was hoping for a more specific answer.
Thanks!