Forum: Queries

Database query discussion.

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

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

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

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

  3. Query becomes uneditable

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

  4. Updating fields selected from a nested query

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

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

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

  6. Arrow multiple question in a query

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

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

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

  8. Question Data type mismatch in criteria expression for overdue action items

    Dscalf1
    • Replies: 11
    • Views: 2,395
    orange
    07-14-2017, 01:19 PM Go to last post

  9. "Data Type Mismatch in Criteria" Error When Attempting to Use Append Query

    EHittner
    • Replies: 11
    • Views: 4,478
    June7
    07-14-2017, 11:13 AM Go to last post

  10. Crosstab Query within another query producing blank result

    Rickochezz
    2 Pages •
    1 2
    2 Attachment(s)
    • Replies: 17
    • Views: 3,622
    Rickochezz
    07-13-2017, 05:23 PM Go to last post

  11. Exclamation TRANSFORM Nz ERROR, Help!

    juliak
    count null strings, counting records, transform
    • Replies: 1
    • Views: 1,066
    ArviLaanemets
    07-13-2017, 12:54 PM Go to last post

  12. Talking Finding Records of Company Stock which is Purchased & Sold

    Ajay371
    • Replies: 7
    • Views: 1,363
    Ajay371
    07-13-2017, 03:04 AM Go to last post

  13. Syntax on Iif Statement?

    aellistechsupport
    4 Attachment(s)
    • Replies: 9
    • Views: 1,673
    ssanfu
    07-12-2017, 03:33 PM Go to last post

  14. Unhappy Make Table Error message

    gheyman
    • Replies: 5
    • Views: 5,130
    Preston
    07-12-2017, 02:19 PM Go to last post

  15. Writing a query based on input from a text box on a form (from query in query list, not in VBA)

    Tenmakk
    • Replies: 3
    • Views: 1,819
    Tenmakk
    07-12-2017, 12:03 PM Go to last post

  16. Count if "YES"

    CJFugate
    • Replies: 4
    • Views: 995
    andy49
    07-12-2017, 11:58 AM Go to last post

  17. Running Count Query Help

    MJD
    count, date and time stamp, group by
    • Replies: 4
    • Views: 1,382
    aytee111
    07-12-2017, 08:01 AM Go to last post

  18. IIf Statement in Criteria

    gheyman
    • Replies: 6
    • Views: 1,736
    Bulzie
    07-12-2017, 07:32 AM Go to last post

  19. Criteria to return results from last 30 days

    Guitarzan
    • Replies: 3
    • Views: 1,135
    JoeM
    07-11-2017, 11:04 AM Go to last post

  20. Totals query or something else?

    JacqueWill
    totals query
    • Replies: 2
    • Views: 957
    CJ_London
    07-11-2017, 09:18 AM Go to last post

  21. Lightbulb enter parameter value dialog box

    exupery
    parameter value, query, sql
    • Replies: 3
    • Views: 1,361
    pbaldy
    07-11-2017, 06:22 AM Go to last post

  22. Query Criteria based on Multi Selection of a List Box?

    gheyman
    • Replies: 5
    • Views: 1,369
    gheyman
    07-11-2017, 04:29 AM Go to last post

  23. Aggregate Results from Union query

    hsduk101
    sql
    • Replies: 1
    • Views: 986
    pbaldy
    07-09-2017, 10:42 AM Go to last post

  24. Character Replacement by Position in String

    J Bhujanga
    • Replies: 5
    • Views: 2,081
    CJ_London
    07-08-2017, 05:16 PM Go to last post

  25. Question Simple Query "math"

    adriennelisa
    • Replies: 1
    • Views: 837
    aytee111
    07-06-2017, 02:42 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