Forum: Queries

Database query discussion.

  1. How to show BLANK (null) counts as ZERO "0"

    KingOf206
    2 Pages •
    1 2
    9 Attachment(s)
    • Replies: 17
    • Views: 3,844
    KingOf206
    07-25-2017, 03:52 PM Go to last post

  2. Query Criteria

    TimC
    • Replies: 1
    • Views: 673
    JoeM
    07-25-2017, 10:32 AM Go to last post

  3. Smile Concatenate

    Alex Motilal
    • Replies: 2
    • Views: 859
    orange
    07-25-2017, 09:44 AM Go to last post

  4. Two tables for one query.

    BADebbie
    • Replies: 4
    • Views: 980
    aytee111
    07-25-2017, 07:13 AM Go to last post

  5. Query Creation - Table Rearrangement

    Crdmster
    1 Attachment(s)
    • Replies: 4
    • Views: 1,098
    Crdmster
    07-24-2017, 03:07 PM Go to last post

  6. runtime error 6 overflow

    nick243
    2 Attachment(s)
    • Replies: 8
    • Views: 1,395
    aytee111
    07-24-2017, 01:52 PM Go to last post

  7. How to total multiple entries?

    newuserthatneedsassistanc
    1 Attachment(s)
    • Replies: 1
    • Views: 776
    JoeM
    07-24-2017, 01:17 PM Go to last post

  8. Monthly dates.

    ghard123
    • Replies: 2
    • Views: 729
    June7
    07-24-2017, 12:03 PM Go to last post

  9. Date variable in query

    jctaylor
    form, function, query
    • Replies: 6
    • Views: 1,386
    Micron
    07-22-2017, 07:49 PM Go to last post

  10. Grabbing Record with a Matching Date or if no match Most Recent Match

    Kaloyanides
    date, query, recent
    • Replies: 1
    • Views: 769
    CJ_London
    07-22-2017, 09:45 AM Go to last post

  11. Summing records between date criteria

    antioch
    • Replies: 5
    • Views: 1,220
    antioch
    07-21-2017, 06:52 PM Go to last post

  12. Using IFF Statement in a Query

    zashaikh
    • Replies: 9
    • Views: 1,634
    zashaikh
    07-21-2017, 07:17 AM Go to last post

  13. How to total by each specific project number?

    newuserthatneedsassistanc
    2 Pages •
    1 2
    9 Attachment(s)
    • Replies: 18
    • Views: 2,629
    June7
    07-19-2017, 02:44 PM Go to last post

  14. How to prevent Enter Parameter Value when Running a Query and a Report

    jeffroth1994
    enter parameter value, query, report 1 Attachment(s)
    • Replies: 13
    • Views: 2,521
    jeffroth1994
    07-19-2017, 11:19 AM Go to last post

  15. Sum Text in group query?

    ArvinFx
    3 Attachment(s)
    • Replies: 6
    • Views: 1,369
    ArvinFx
    07-18-2017, 07:49 PM Go to last post

  16. Rounding up

    UT227
    • Replies: 5
    • Views: 1,256
    Preston
    07-18-2017, 10:35 AM Go to last post

  17. If query result is empty, put 0 as default value

    themushroomking
    default value, query, zero values 1 Attachment(s)
    • Replies: 8
    • Views: 2,537
    JoeM
    07-18-2017, 09:07 AM Go to last post

  18. LIMITING Query results from multiple tables

    moneypennie21
    distinct, limit, query 5 Attachment(s)
    • Replies: 8
    • Views: 1,685
    orange
    07-18-2017, 06:36 AM Go to last post

  19. need help w/query selecting only the first row in each grouping, deleting the rest

    oliver1535
    1 Attachment(s)
    • Replies: 6
    • Views: 1,218
    oliver1535
    07-17-2017, 09:51 AM Go to last post

  20. Stripping values out of a field to create Combo box rows

    tonygg
    1 Attachment(s)
    • Replies: 6
    • Views: 1,214
    ranman256
    07-17-2017, 06:00 AM Go to last post

  21. Query becomes uneditable

    Tony Gilbert
    • Replies: 7
    • Views: 1,424
    Tony Gilbert
    07-16-2017, 07:21 PM Go to last post

  22. Updating fields selected from a nested query

    tonygg
    • Replies: 12
    • Views: 1,696
    tonygg
    07-16-2017, 08:47 AM Go to last post

  23. Update a field based on a value of another field

    Khalil Handal
    update field
    • Replies: 5
    • Views: 1,290
    June7
    07-16-2017, 02:21 AM Go to last post

  24. Arrow multiple question in a query

    mnjohn
    • Replies: 3
    • Views: 861
    mnjohn
    07-15-2017, 01:05 AM Go to last post

  25. Grouped query results how to refer to them in Macro

    moneypennie21
    9 Attachment(s)
    • Replies: 14
    • Views: 16,411
    ssanfu
    07-14-2017, 06:04 PM Go to last post

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 15 replies or 150 views
Hot thread with unread posts
More than 15 replies or 150 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

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