Khalid-
Run this query:
SELECT ConsignmentNo, CartonNo, CartonSuffix
FROM CollectionVoucher
GROUP BY ConsignmentNo, CartonNo, CartonSuffix
HAVING Count(*) > 1
That should show you the duplicate rows.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Oct 20, 2014, at 12:24 PM, khalidtanweerburrah@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John,
Yes you are right CartonNo starts from 1 for each new Consignment.
The same error is still coming while combining ConsignmentNo, CartonNo and CartonSuffix.
Also please consider that now CartonSuffix field has throughout ZERO value.
Khalid
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (12) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar