Results 1 to 2 of 2
  1. 02-25-2010, 06:01 AM #1
    speak2des
    speak2des is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2010
    Posts
    1

    creating automated ticket number

    am working on an access project. i have a table comprising item_id, date made, vendor, unit price, amount and remarks.


    I want a report or table which will have ticket_id generated per day per vendor.
    How can i go about this.
    Thank you
    Reply With Quote Reply With Quote
  2. 02-25-2010, 11:32 AM #2
    MAF4Fam6's Avatar
    MAF4Fam6
    MAF4Fam6 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Location
    Fruit Heights, Utah USA
    Posts
    140
    A few questions for you:
    1. Is your item_id set to AutoNumber (Data type)?
    2. What is the amount field being used for?

    -RC
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. automated macros?
    By tom4038 in forum Programming
    Replies: 1
    Last Post: 09-24-2009, 02:57 AM
  2. Automated Letter Composition
    By jmwheatley in forum Programming
    Replies: 7
    Last Post: 09-20-2009, 05:20 PM
  3. Automated many Rpts from one??
    By techexpressinc in forum Reports
    Replies: 0
    Last Post: 07-21-2009, 08:20 AM
  4. help creating a sequential number for records in a table or query
    By rthomas in forum Access
    Replies: 1
    Last Post: 01-31-2009, 10:43 AM
  5. Sum Of Positive Number and Negative Number
    By maysamab in forum Reports
    Replies: 1
    Last Post: 10-20-2008, 04: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
  •  

Forum Rules

Other Forums: Microsoft Office Forums