I'm trying to mimick functionality of the database that I originally have in Access on SQL Server 2005. So far the greatest issues I have is to get my queries to work in a similar manner. Namely, see code below
I thought that putting Access front end onto the SQL Server 2005 backend would allow me to have user input as I do in Access database. But apparently it isn't that simple.
Is there a good way to solve this problem? I'm not committed to using ADP, I just thought it would let me use Access GUI for the front end. I don't have too much experience with either Access db or SQL db, so you may have to spell it out for me :-)
When I run a syntax checker on this query (which works in Access), I get the following error:
"ADO error: Invalid column name 'Enter 1st date-Enter as YYYYMMDD'.
Invalid column name 'Enter 2nd Date-Enter as YYYYMMDD'.
Statement(s) could not be prepared.
Deferred prepare could not be completed."
SELECT Sum(MasterTable.amount) AS SumOfamount, MasterTable.number, Count(MasterTable.item) AS CountOfItem, MasterTable.updatedNumber
WHERE (((MasterTable.date) Between [Enter 1st date-Enter as YYYYMMDD] And [Enter 2nd Date-Enter as YYYYMMDD]))
GROUP BY MasterTable.number, MasterTable.updatedNumber
ORDER BY Count(MasterTable.item) DESC;