Tech Support banner
Status
Not open for further replies.
1 - 1 of 1 Posts

·
Registered
Joined
·
34 Posts
Discussion Starter · #1 ·
Hi, i'm making an online database interface using access and frontpage, i've been trying to make one of my queries search between dates like it does in access however when i try to use this function online an error message appears saying that 2 variables were expected.
The SQL code for the query is:



SELECT Transaction_File.Product_ID, Product_Table.Supplier_ID, Product_Table.Product_Name, Transaction_File.Date, Transaction_File.Sales AS [Sum Of Sales In A Day], Transaction_File.Deliveries AS [Sum Of Deliveries In A Day], Transaction_File.Processed, [Please Enter First Date] AS [First Date], [Please Enter Second Date] AS [Last Date]
FROM Product_Table INNER JOIN Transaction_File ON Product_Table.Product_ID = Transaction_File.Product_ID
WHERE (((Transaction_File.Date)>'%::[Please Enter First Date]::%' And (Transaction_File.Date)<'%::[Please Enter Second Date]::%'))
ORDER BY Transaction_File.Date;



Please help me, and tell me of any modifications that could be made to this code to allow it to work properly.
 
1 - 1 of 1 Posts
Status
Not open for further replies.
Top