Unanswered: Access Report ability to choose 1 of 2 dates to sort
I have created a reporting form to create production reports for the company I work for. Half the people want to have there reports in ascending order based off of Due Date and half based on Mail Date. Both these fields exists but I am having trouble figuring out a way to let the Form user select which date they want there report indexed on. Is there a way to have a combo box that has "Mail Date" and "Due Date" on the form that the user can select resulting in a report in ascending order based off of the one selected in the combo box? I am a total noob so any help would be greatly appreciated.
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.