Results 1 to 2 of 2
  1. #1
    Guru86 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2013
    Posts
    3

    Need Help Creating a table which repeats the Jb number


    I am currently building a table that keeps track of concur invoices, The problem is that the expenses are coming at different dates but have the same job number, but right now it will not let me repeat the same job number. How can i get this to work?

  2. #2
    rzw0wr is offline I will always be a newbie
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Indiana
    Posts
    479
    I am thinking your tables are not correct yet.
    Sounds like you need a table for expenses related to invoices. 1 to many.

    Make a new table for expenses.

    Click image for larger version. 

Name:	table.PNG 
Views:	3 
Size:	5.5 KB 
ID:	12868

    Dale

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

Similar Threads

  1. Replies: 2
    Last Post: 08-15-2012, 02:21 AM
  2. Header Repeats at Top Page Problem
    By KelleyM in forum Reports
    Replies: 7
    Last Post: 07-02-2012, 02:47 PM
  3. Access Data Repeats
    By coreytba3 in forum Access
    Replies: 1
    Last Post: 08-04-2011, 01:00 PM
  4. Random number generators with no repeats
    By CJ508 in forum Access
    Replies: 5
    Last Post: 10-29-2009, 07:30 AM
  5. Replies: 1
    Last Post: 01-31-2009, 10:43 AM

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