INSERT INTO giving application error

[Philly44]

I have a table that is used to track mail history. One of the ways it gets updated is through an INSERT INTO query. The problem I have is this, when I try to run the query I get an application error(Division by Zero). It doesn't make any sence to me. I can see the datasheet of the query no problem. The syntax is as follows:

INSERT INTO tblMailHistory (CustID) SELECT DISTINCT CustID FROM tblReport;

tblReport is a temporary table used for geerating reports and things. Any help would be greatly appreciated. Thanx

 

[downwitchyobadself]

Do you have any null values in the CustID field? What happens if you make a select query with a field

CustIDDivTest: 1/[CustID]

Does it run?

 

[Philly44]

I figured out the problem. I changed DISTINCT to DISTINCTROW and it works fine now. I have no idea why this made a difference but hey it works. Thanx anyways