Recent content by srm7028

Ok first I want to thank you for all your help. I got the find duplicates to work by modifying part of what you had in the SQL view In (SELECT [PartNumber] FROM [tblParts] As Tmp GROUP BY [PartNumber],[CreationDate] HAVING Count(*)>1 And [CreationDate] = [tblParts].[CreationDate]))) and...

Syntax Error Didnt work I found something that did work by typing in it the criteria area but you have to know the CustomerNum an input box comes up prompting for a CustomerNum. I need it to do the same as the wizard would do it. I searched and found many ways that didnt work. If I could just...

I need to run a find duplicates query and unmatched query without the use of the wizards. I do not have it installed and do not have the office cd anymore to install it. I have Access2000. Any help is much appreciated again. Thx Sean

Tried it again and it worked!!! Thx so much !!!

Thx anyway Didnt work

I have a top hits table with a hits and at bats field . In order to get the batting average hits/atbats but the total i am am getting is too long i need to round it or specify somehow that i only want 3 spaces after the decimal .360 instead of .3604759837458. I have searched help and everywhere...