+ Reply to Thread
Results 1 to 4 of 4

List of Not Reported Receipt

  1. #1
    Forum Contributor
    Join Date
    07-21-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2019
    Posts
    292

    Lightbulb List of Not Reported Receipt

    Hello every one,

    Can some one help me that how to make a form and table which can give me a report as below:-

    For example My branch office has a book of receipt from 1 to 1000. and daily they are reporting me used Rcepits..I want ot controle that what is missing..

    Table will be liek below


    1
    2
    4
    10
    11
    12
    20

    i want a to creat a report which should give me as below

    3
    4
    5
    6
    7
    8
    9
    13
    14
    and so on

    Thanks in advance for any help

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,851

    Re: List of Not Reported Receipt

    Suggest you create table with two fields.

    ReceiptNr. PK Autonumber
    ReceiptUsed Yes/No checkbox

    In a query.

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    07-21-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2019
    Posts
    292

    Re: List of Not Reported Receipt

    Thanks Aladsidman,

    Thanks for your reply, can you pls creat and a file for me as i m new in access..Bondle of thanks

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,851

    Re: List of Not Reported Receipt

    Time to learn how to do this yourself. If you are looking for someone to do the work for you, suggest you hire a programmer. This site is here to assist you -- not do the work for you. Here is a site to assist you in your learning experience.

    http://www.accessmvp.com/strive4peace/

    Good luck and post back with any issues you may encounter as you begin your Access learning experience.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1