Search results

I'm having a problem exporting my table as text and having three fields reporting only 2 decimal places instead of the 4 that i need. I'm using Access 200 on Windows XP Pro. I searched the forums and the only thing i could find was to create a querry and using ColumnName: str([dblNumber])...

The name for the duplicate querry is "Find duplicates for AllSourcesfromCDM". I made sure the I removed indexing from all of the fields except the "Address" field and went through the procedure again and came up with the same number of records in the new table. When i do the append queery...

There isn't a name for the find duplicate querry. If you click on querry on the left menu then click "New" you get a list of 5 querries that you can make: Design View, Simple Querry Wizard, Crosstab Querry Wizard, Find Duplciates Querry Wizard, and Find Unmatched Querry Wizard. I chose "Find...

Thanks for the help youa re giving me Scott. I'm a very basic user of Acces, so I don't know how to do a DSUM. Could you explain how to do that? Secondly, I can't post my DB because it has confidential data in it. Perhaps I could just post the Address column for you to look out. But, I...

Ok, the recordcount is 17196 and I dont know how to figure the sum of all of those (and of course i'm not doing it by hand). For the second querry I'm doing this: How to delete duplicate records from a table in Access 2000 View products that this article applies to. Article ID : 209183 Last...

Well the find duplicates querry is the one from the "New Querry" menu. Here is the SQL for that: SELECT First([ADDRESS]) AS [ADDRESS Field], Count([ADDRESS]) AS NumberOfDups FROM AllSourcesfromCDM GROUP BY [ADDRESS] HAVING Count([ADDRESS])>1; As for the append querry it is from the Microsoft...

Nope. There are records missing that had no duplicates in the orginal table and some that had duplicates. They should be in the new table, but are not. When you do the find duplicate querry you are basically seeing all the records that have a duplicate in the address field. Therefore, there...

Hey, all! Thanks for helping, here is my situation. I have a table with about 70,000 records that have duplicate Address field values. The rest of the field values for those records are different. When I do a find duplicate querry I get the result that 17,000 records have the same address...

Ok, thanks for all your help. I guess i could just copy/paste it all into the caption.

Ya, that is what I'm looking for. However, when I go to the CAPTION property for the field it does not give me an option to choose DESCRIPTION. It seems to me that I would have to type it all in again (which I'm trying to get around doing). Can I just type DESCRIPTION and it work? I'm using...

I am creating a form utilizing all of the fields of my table (table1). I want the form label names to be from the description of the fields from table1. I have over 50 fields and was wondering if I could do this automatically. Example: table1 Field: Description: Policy_Date...