Hi all,
I have a table of Product names and I need a sql code to pull products name till a speciific products name, like :
For example, If the target record is "Canon i70", SQL code must select products names until the target product name that are 1 to 7.
"HP pro 400"
"AOC T96"
"HP 220"
"Canon 9000F"
"Dell 2330"
"AOC C23"
"EPSON 100"
I also tried this :
But It didn't work.
I have a table of Product names and I need a sql code to pull products name till a speciific products name, like :
For example, If the target record is "Canon i70", SQL code must select products names until the target product name that are 1 to 7.
"HP pro 400"
"AOC T96"
"HP 220"
"Canon 9000F"
"Dell 2330"
"AOC C23"
"EPSON 100"
I also tried this :
Code:
SELECT top DCount("ID","tbl_printers","ProductName = '" & Canon i70 & "') ProductName
FROM tbl_Printers;
But It didn't work.