Duplicate data

[richardplr]

Hi,

Anyone has experience for barcode. Example, if you scan the first time then it will appear total 1 and if you scan again with the same barcode, then the total will change to 2 ...etc.

Anyone has experience, please share.

Thank you



Regards,
Richard Tan

 

[damFlard]

Well, if you save the entries that came from the barcode reader in a table, a simple query with a count can generate the number of entries.
Let's say the value of the barcode is 1234.

SELECT Table1.value, Count(Table1.value) AS CountOfvalue
FROM Table1
GROUP BY Table1.value
HAVING (((Table1.value)="1234"));

 

[richardplr]

Well, if you save the entries that came from the barcode reader in a table, a simple query with a count can generate the number of entries.
Let's say the value of the barcode is 1234.

SELECT Table1.value, Count(Table1.value) AS CountOfvalue
FROM Table1
GROUP BY Table1.value
HAVING (((Table1.value)="1234"));

Hi DamFlard,

Thank you for your kind respond. I got one question on this. You mentioned that I have to indicate what is the number barcode number is 1234 what if I don;t have a fit number, can I made the barcode number as dammies.

Please advise