Forum: Queries

Database query discussion.

  1. Question Conditional Counting?

    justplaincorey
    • Replies: 1
    • Views: 712
    ItsMe
    05-26-2014, 07:37 AM Go to last post

  2. addition update; add fieldA value to fieldB, two different tables

    tynus
    • Replies: 1
    • Views: 1,126
    Bob Fitz
    05-26-2014, 03:02 AM Go to last post

  3. Exclamation Unmatching 2 queries comes out BLANK

    BigBig5
    • Replies: 1
    • Views: 838
    ItsMe
    05-24-2014, 06:15 PM Go to last post

  4. Exclamation Add a calculated field that is based on more than one row within the same query

    matidiaz
    1 Attachment(s)
    • Replies: 2
    • Views: 1,394
    matidiaz
    05-23-2014, 08:35 PM Go to last post

  5. Query SUM total not correct with more than two tables

    tdoolittle
    • Replies: 1
    • Views: 1,018
    June7
    05-23-2014, 03:38 PM Go to last post

  6. Best way to perform series of updates

    mrlddst
    iif, switch, update table
    • Replies: 7
    • Views: 1,607
    pbaldy
    05-23-2014, 11:05 AM Go to last post

  7. Question How to Find Mismatch of two fields in One Query?

    BigBig5
    • Replies: 1
    • Views: 814
    pbaldy
    05-23-2014, 10:04 AM Go to last post

  8. Query To Sum Daily Sales Figures By Weekend and Weekdays

    deluga.69
    • Replies: 3
    • Views: 1,445
    deluga.69
    05-23-2014, 07:50 AM Go to last post

  9. Project Duration

    Ian Frost
    • Replies: 2
    • Views: 879
    hapm
    05-23-2014, 06:48 AM Go to last post

  10. Recognizing non-record as zero

    shindb81
    • Replies: 5
    • Views: 971
    shindb81
    05-22-2014, 03:54 PM Go to last post

  11. Exporting memo fields more than 255 characters from a query

    CaperTS
    export access to text, query help, truncated
    • Replies: 1
    • Views: 1,251
    June7
    05-22-2014, 03:54 PM Go to last post

  12. Build field name in an expression, then call the field?

    DB88
    • Replies: 7
    • Views: 1,934
    lfpm062010
    05-22-2014, 06:17 AM Go to last post

  13. How to find Voids in data?

    madwildfire
    date ranges
    • Replies: 4
    • Views: 1,104
    ItsMe
    05-21-2014, 11:05 PM Go to last post

  14. Cool How to refer to the Month of a date field type to be used in a query

    behnam
    date, query
    • Replies: 2
    • Views: 1,278
    ranman256
    05-21-2014, 11:10 AM Go to last post

  15. Return one row per Member comparing multiple episodes for each member

    laurastreng
    • Replies: 3
    • Views: 2,157
    June7
    05-21-2014, 10:15 AM Go to last post

  16. How to return the number of checked items in a table.

    behnam
    checkbox query, count, query
    • Replies: 2
    • Views: 1,503
    behnam
    05-21-2014, 06:16 AM Go to last post

  17. Queries - Count items in a column

    turboace
    • Replies: 1
    • Views: 903
    lfpm062010
    05-21-2014, 05:12 AM Go to last post

  18. Writing a query to limit only one year when multiple years can occur

    klaidlaw
    query by date, query criteria
    • Replies: 2
    • Views: 1,264
    klaidlaw
    05-20-2014, 02:28 PM Go to last post

  19. Switch from using DLookup to using a Query to lookup customer info.

    dmon2010
    • Replies: 5
    • Views: 1,346
    ItsMe
    05-20-2014, 10:39 AM Go to last post

  20. Search multiple fields in one table

    BWGreen
    • Replies: 1
    • Views: 938
    ranman256
    05-20-2014, 10:37 AM Go to last post

  21. Question dates - 2 digit year

    RCDAwebmaster
    • Replies: 5
    • Views: 1,976
    RCDAwebmaster
    05-20-2014, 08:14 AM Go to last post

  22. Update table with a max value from another table

    Bigdwg
    • Replies: 5
    • Views: 1,043
    June7
    05-19-2014, 08:52 PM Go to last post

  23. Parameter are not allowed in queries that cant be displayed graphically.

    Shilabrow
    • Replies: 3
    • Views: 2,930
    ItsMe
    05-19-2014, 08:19 PM Go to last post

  24. Query insert with too many conditions...?

    gmaster
    • Replies: 1
    • Views: 878
    June7
    05-19-2014, 11:49 AM Go to last post

  25. Group by Help and Count or Sum function

    Shilabrow
    • Replies: 3
    • Views: 881
    June7
    05-18-2014, 06:21 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