Search results

  1. G

    Concatenate and delete characters in Query

    I want to set up a calculated field in one of my queries. I need to concatenate characters to the beginning and end of my chosen field, this part I know how to do. What has me stumped is how do I remove a certain character. Here is what I have: Type: "C.REGT.000" & [table1]![Field1] & "L -...
  2. G

    Remove duplicate records without using append query and make a table

    I would like to remove all duplicate records from a table I have setup. I have created a find duplicates query using the wizard which works great. What would I put in for a statement to add to the query that would delete the duplicates. It doesn't matter which record gets deleted as long as...
  3. G

    Concatenating data in a table = How?

    I have a simple table setup with 4 columns which are from left to right: last name,first name, id, Full name I want to have the "full name" column display data from both the last name & first name columns. I'm using the full name column to populate a combobox in a form. I can concatenate in a...
  4. G

    Data disappearing from form,but not the table

    I have a simple table and form set up. When I close access and reopen it all the records stored in my form are gone. The data still resides in the table it just disappears from the form. Is this normal? It happens to all my forms in this .accdb. It kind of defeats the purpose of having the...
Back
Top Bottom