Results 1 to 4 of 4
  1. #1
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664

    Payments Table and Form

    I just created the payments table in the Ceil Inn MS Access 2010 tutorial. It came at a late stage


    in the tutorial. However, I needed to use it much sooner when working the tutorial. It seems
    that you must create the table before using it.

    Is this sloppy tutorial organization or what? Seriously what is going on?

    Any help appreciated.

    Thanks in advance.

    Respectfully,


    Lou_Reed

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,527
    What do you need? I'f you have a tPayment table, the fields would be
    MasterID. (The master key From that table)
    PayID
    Paydate
    Amt
    PayType (cash,check,card)
    Name
    memo

  3. #3
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    In an early part of the Ceil Inn tutorial one requires the use of a Payments Table which has not been
    created! So I created one just to get past that early stage. Then in the last half of the tutorial one is asked to
    create a payments table. but this is after you have used it.

    This make no sense. Using a table before it is created.

    The Ceil Inn tutorial can be found here:

    http://www.functionx.com/access/appl...ns/ceilinn.htm

    If you examine it you will see what I mean.

    Any help appreciated. Thanks in advance.


    Respectfully,

    Lou_Reed

  4. #4
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    I will try what you said.

    Thanks for replying.

    Respectfully,


    Lou_Reed

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

Similar Threads

  1. Replies: 6
    Last Post: 12-13-2014, 09:20 PM
  2. Cumulative totals for summary payments
    By maxmaggot in forum Forms
    Replies: 2
    Last Post: 04-06-2014, 12:50 PM
  3. Invoice and payments received
    By esther6086@lowcountry.com in forum Queries
    Replies: 1
    Last Post: 08-13-2013, 06:28 PM
  4. Need To Sum Payments in Query
    By burrina in forum Queries
    Replies: 3
    Last Post: 11-27-2012, 05:35 PM
  5. Replies: 3
    Last Post: 07-18-2011, 04:14 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