Hi,
Isladogs was kind enough to point me to her updated code when I was having problems, yet I still am having issues and hoping its quick to fix.
The code works in my query if I don't place a where clause, if I remove it, it works fine. I get error 3061. Too few parameters, expected 1.
I need this every time I run this query, so it ranks the records from 1 to whatever, which I then intend to turn into an update query to use the data at a later date. It's for grouping purposes in long run.
Query - Test
Query - Query1
Isladogs was kind enough to point me to her updated code when I was having problems, yet I still am having issues and hoping its quick to fix.
The code works in my query if I don't place a where clause, if I remove it, it works fine. I get error 3061. Too few parameters, expected 1.
I need this every time I run this query, so it ranks the records from 1 to whatever, which I then intend to turn into an update query to use the data at a later date. It's for grouping purposes in long run.
Query - Test
Code:
SELECT tblGoodsINDetails.ID, tblGoodsINDetails.Description, tblGoodsINDetails.PalletCount, tblGoodsINDetails.DeliveryRef, tblGoodsINDetails.labeldetailsCOUNTER
FROM tblGoodsINDetails
WHERE tblGoodsINDetails.DeliveryRef=[Forms]![frmGoodsINNewpreadvise]![TextDeliveryRef];
Query - Query1
Code:
SELECT Serialize("Test","ID",[ID]) AS RowNum, Test.ID, Test.Description, Test.PalletCount, Test.DeliveryRef, Test.labeldetailsCOUNTER
FROM Test;