Search results

H there, I would like not just to elminate duplicates (i know how to do that) but find out exactly what records are duplicates. I have read through posts on this - they recommend using "Find Duplicates Wizard" - which is not installed/available on my computer. I am using Access 97 and the...

Thanks for taking the time to answer I got the query to work by using your suggestion by selecting all records from habitat info table and only those that match from the other two - that got it to work - i can breathe a sigh of relief

Hello Could someone tell me what I wrong with my table design ( I have attached a snapshot of the relationship window - not all tables are shown, just ones that are in problematic query) my problem: When i add table main, habitat info, stream stream site, and reach data to a query it is...

no need to answer - figured it out

Hi, This is a rather dumb question but here it goes anyways. I have one excel file - fields from this excel file need to be apended to 2 different tables (main table and stream table). There is a one to many relationship between the main table and the stream table. The main table contains...

thanks You were right - fields had the same name (duh! - actually, I had orignally given the fields different names, but they were truncated and ended up with the same field names) All the same, thank you for answering my question

I am trying to import a table (.dbf) into Access 97. I get the message "can't define field more than once" What is my problem and how can I fix it? Thanks

answered my own question wow, for the first time in my life I have answered my own Access question (just need to change "integer" to "long") All the great help from this board must be rubbing off on me.

wow, for the first time in my life I have answered my own Access question

I have been using the following VBA code to update the blank records in a field with sequential numbers. ******* Private Sub Command0_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim InitialNumber As Integer Dim i As Integer InitialNumber = 36084 Set db = CurrentDb Set rs =...

I have a table with several "comments" fields (data type:text). I would like to merge all the comment fields into one. Is this possible (or dumb????) Example: Current format: comments 1 ( hot ) comments 2 ( cold) comments 2 (warm) Desired format: Comments (hot cold warm) Thanks for...

Thanks for the examples and taking the time to answer - much appreciated

Thanks for your answer - I have taken your advice

I was recently given a db which has fields in some of its tables designed to store calculated values (ie: avg_mass and % gravel) In fact, there is a "summary table" which consists only of calculated fields. After reading through posts on calculated fields, I have learning that this is not a...

Thanks Rich Can you please tell me why? (I didn't design this database - always hesitent to change someone elses work)

I have a table that I'm not really happy with. At the moment it contains fields both of totals and averages Example: % fish and average fish Do you think a should just create 2 tables, one for totals and one for averages? Or is quite fine the way it is? Just trying to think of any confusion...

Thanks for taking the time to reply and explain things I feel better now

I have reading about duplicate records in serveral Access forums and am trying to figure out whether I have a serious problem. A few examples: Example # 1: For example, users will enter into the "rivers" field which river they saw a fish (ie: Fraser river). There will be many observations...

point taken :cool:

I accidently truncated records when appending them to a field (my field size was too small, guess I won't make that mistake again!) As a result the records that were append are missing a few zero's (to be exact, "00-000") How can I add on 00-000 to my records? (Except where the record value...