Results 1 to 2 of 2

Thread: Auto Pick Sum into new table

  1. #1
    Join Date
    Aug 2008
    Posts
    52

    Auto Pick Sum into new table

    I have a database that gives me a kind of daily sales report.
    I want a situation where the access database will be able to summarise my daily sales and pick the content to another table base on that day's date.
    Can any body direct me on what to do.
    Thanks
    Engr. Clement

  2. #2
    Join Date
    Mar 2006
    Location
    Oklahoma City, OK
    Posts
    184
    Quote Originally Posted by Engr. Clement View Post
    I have a database that gives me a kind of daily sales report.
    I want a situation where the access database will be able to summarise my daily sales and pick the content to another table base on that day's date.
    Can any body direct me on what to do.
    Thanks
    Engr. Clement
    If you are wanting to select record do the current date try using:

    Code:
    Where [YourDateField] = Date()
    if you want a range, for example the previous seven days you could use:

    Code:
    Where [YourDateField] Between ( Date() - 7 )  and ( Date() -  1)
    Boyd Trimmell aka HiTech Coach
    Microsoft MVP - Access Expert
    [SIGPIC][/SIGPIC]
    Office Programming 25+ years as a Software Developer specializing in:
    Business Process Management
    Accounting/Inventory Control
    Customer Relations Management (CRM)
    Electronic Data Interchange (EDI)

Posting Permissions

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