Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Location
    dallas
    Posts
    14

    One table multiple fields identical properties.


    I ahve a table with fields [invoice1], [amount1], [paid1](check box),[invoice2], [amount2], [paid2](check box),[invoice3], [amount3], [paid3](check box). There are other fields that tie into other tables. I need query that will append theses fields listed into one column([invoice1], [invoice2] and [invoice3]) and so on with the other. I also just want the false values for the check boxes. Then this will need to be turned into a form so a Supervisor can check off the ones that have been paid. Is this possible?

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    Andrew,

    I urge you to consider changing the layout of your table. The current design is a bad idea, and you should think about going to a more normalized set-up. If you give some more details about your application, I can make more concrete recommendations.

  3. #3
    Join Date
    Sep 2006
    Location
    dallas
    Posts
    14
    took your advice works great now i restructured my whole database and some other small issues were taken care of to.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Inserting multiple records into a table
    By New2Access in forum Programming
    Replies: 1
    Last Post: 07-07-2011, 09:18 PM
  2. multiple fields in separate records
    By Fredo0709 in forum Database Design
    Replies: 9
    Last Post: 04-09-2010, 12:23 PM
  3. Table related to multiple tables by single ID
    By MrTumnus in forum Access
    Replies: 1
    Last Post: 11-17-2009, 02:05 PM
  4. Validation on identical text question
    By edrahl in forum Database Design
    Replies: 1
    Last Post: 02-26-2008, 09:38 AM
  5. Import multiple dbf files into existing table?
    By sbg2 in forum Import/Export Data
    Replies: 0
    Last Post: 06-12-2006, 02:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums