I currently have 3 different append QRYs that populate the same table. The reason for that is so that I can alter the data based on certain criteria. Duplicate will appear on the report which will cause the warning to pop up stating so many records weren't added. I removed the warning with DoCmd.SetWarnings False but i'd like to have it display a message box stating how many records WERE added. Please help!