I am new to Access. I just converted our database to Access 2010 and have published to SharePoint. I just need simple reporting capabilities (no data modification) for our customers to access their data. All data input will be done in house and a file will be uploaded daily.
I had a simple report in Access that used a report form to allow the user to enter a date range for their data – a Date From and a Date To field. The report called a query which had criteria “Between [Forms]![ClaimsFiled]![Date1] And [Forms]![ClaimsFiled]![Date2] – very simple and it worked fine.
I did read on one of these forums that “You cannot use a form to collect query parameters in a web database.” Is that true?
So I tried to modify the new query, figuring I could just have to user run the query and not the report – they would probably just download the raw data to Excel anyway. But when I try to enter this in the query I seem to be only allowed to do >=Date1 or <=Date2 I can’t do both???
I had a simple report in Access that used a report form to allow the user to enter a date range for their data – a Date From and a Date To field. The report called a query which had criteria “Between [Forms]![ClaimsFiled]![Date1] And [Forms]![ClaimsFiled]![Date2] – very simple and it worked fine.
I did read on one of these forums that “You cannot use a form to collect query parameters in a web database.” Is that true?
So I tried to modify the new query, figuring I could just have to user run the query and not the report – they would probably just download the raw data to Excel anyway. But when I try to enter this in the query I seem to be only allowed to do >=Date1 or <=Date2 I can’t do both???