Search results

  1. R

    How to transform record entries to fields in another table?

    oops, typo... "I do understand what is meant by "documenting" " should read: "I do NOT understand what is meant by "documenting" "
  2. R

    How to transform record entries to fields in another table?

    Thanks again. I created the database as per your instructions (see attached) and compared it with Northwind. This is my first encounter with subforms, hence some questions remain: 1. Where's the data? Opening the subforms in Northwind shows all fields and corresponding records from the...
  3. R

    How to transform record entries to fields in another table?

    Thanks. Done, as per your instructions. # of records: MakeModel....259 Options....110
  4. R

    How to transform record entries to fields in another table?

    Thank you both for clear and cogent replies. 1. I've attempted the crosstab query from the Options table, but get the error: "Not Enough Fields," since the Options table now has only three fields: "Option" and "Option Description," plus an auto-number primary key. 2. I did create a...
  5. R

    How to transform record entries to fields in another table?

    I have one table called "Make and Model," with two fields: MAKE, and MODEL. Another table, called "Options," has two fields: OPTION NAME, and OPTION DESCRIPTION. I would like to create a third table, with fields for MAKE, MODEL, and one Yes-No field for each OPTION NAME (which exist as Records...
Back
Top Bottom