Results 1 to 5 of 5
  1. #1
    newtoAccess is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    226

    Creating numbered tickets for door prices

    Keep in mind I am new to Access.

    I have created a report showing my ticket.


    I want to put the same number on each side of the ticket.
    I need tickets 0001 to 0200

    Do I create an update or apend query. How do I do it?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You don't need a query. This can all be done on a report with visible and invisible controls and using the Sum feature of the control.

  3. #3
    newtoAccess is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    226

    how do I get started?

    You better point me in the write direction?

  4. #4
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Do you have these ticket numbers stored in a Table?

    If so just use the same field as the Control Source for two different text boxes.

    If you don't have these numbers stored then we need to try something else.

    Let me know what you want to do.

  5. #5
    newtoAccess is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    226
    Yes they are in a table.

    I was able to create fields the would link to the table and show the ticket numbers.

    Thanks
    That works

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

Similar Threads

  1. A column numbered: 1,2,3,4,5...
    By eezing in forum Queries
    Replies: 1
    Last Post: 08-18-2009, 09:44 PM
  2. Help with creating a database
    By ITChevyUSSNY in forum Access
    Replies: 0
    Last Post: 07-31-2009, 05:48 AM
  3. creating subdatasheets
    By spyter in forum Access
    Replies: 0
    Last Post: 12-07-2008, 10:35 AM
  4. Creating database
    By ramzyamal in forum Database Design
    Replies: 1
    Last Post: 05-07-2007, 08:53 AM
  5. Creating a chart
    By Tim Wuckowitsch in forum Reports
    Replies: 0
    Last Post: 10-31-2006, 11:39 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