Recent content by chundusmgs

  1. C

    A simple Query...or so I thought!!

    Do you want to delete duplicate record or duplicate field. Duplicate record means all fields have the same value. Deleting dupicate field use group by option. Deleting duplicate records visit learnmsaccess.weebly.com. You will find the answer
  2. C

    Is it possible to start record ID from any number?

    uploaded file in learn-msaccess.weebly.com
  3. C

    Is it possible to start record ID from any number?

    i will upload the sample db in my website learn-msaccess.weebly.com. pl download.
  4. C

    How to delete duplicate records in a table

    HOW TO DELETE DUPLICATE RECORDS create a query with all the fields and an additional exp field combining all fields like=[field1] &[fild2] &[field3] . Run this qry as a make table query. Copy this table to another table with structure only.Fix the expression field as unique key and append to...
  5. C

    Is it possible to start record ID from any number?

    create another table with a numeric field.Enter the number you want to start from. Append this from append query to your quotes table id field.
  6. C

    Way to fill blank flds w/dflt when appending data to tables?

    design view of the table enter the default value. enter yes in the required property.
  7. C

    Way to fill blank flds w/dflt when appending data to tables?

    in the design viw enter the default value and also required to yes.
  8. C

    Parsing the table field

    you can use update query with mid function.for further details contact chundusmgs@rediffmail.com
  9. C

    Queries possabiltys

    format renewaldate as below FORMAT$([renewaldate],"mmm-yyyy")-enter this as expreesion and use group by option. memberno exp1-as above count groupby i hope this will solve the problem
  10. C

    use iif function,

    use iif function,
See more
Back
Top Bottom