Forum: Queries

Database query discussion.

  1. Using a query to sum the number of times a string appears in a field

    radguy
    4 Attachment(s)
    • Replies: 7
    • Views: 2,258
    June7
    07-31-2014, 05:14 PM Go to last post

  2. IS NULL in criteria question

    McArthurGDM
    1 Attachment(s)
    • Replies: 12
    • Views: 1,768
    June7
    07-31-2014, 04:52 PM Go to last post

  3. Random Record pull

    haydenbl
    • Replies: 2
    • Views: 873
    orange
    07-31-2014, 03:04 PM Go to last post

  4. Grouping By Week Using a Fixed Start Date

    abinboston
    • Replies: 1
    • Views: 1,162
    June7
    07-31-2014, 11:55 AM Go to last post

  5. Deleting partial data in fields

    rileyma
    • Replies: 7
    • Views: 1,719
    June7
    07-31-2014, 11:42 AM Go to last post

  6. How to get the top 10 records for every salesperson

    snipe
    1 Attachment(s)
    • Replies: 6
    • Views: 1,004
    snipe
    07-31-2014, 10:08 AM Go to last post

  7. Separating fields

    markbitman
    queries, query to separate fields
    • Replies: 2
    • Views: 1,328
    cbende2
    07-31-2014, 09:05 AM Go to last post

  8. Selection Query not working properly

    zipaway
    1 Attachment(s)
    • Replies: 9
    • Views: 2,077
    zipaway
    07-31-2014, 06:56 AM Go to last post

  9. Queries using various databases

    roemerle
    • Replies: 4
    • Views: 1,241
    roemerle
    07-30-2014, 03:40 PM Go to last post

  10. Querying specific weeks data within any given year?

    McArthurGDM
    • Replies: 1
    • Views: 1,117
    lfpm062010
    07-30-2014, 02:02 PM Go to last post

  11. form criteria

    slimjen
    • Replies: 2
    • Views: 810
    slimjen
    07-30-2014, 10:22 AM Go to last post

  12. Help With Grouping By Hour

    amyjh38
    • Replies: 3
    • Views: 1,245
    pbaldy
    07-30-2014, 09:04 AM Go to last post

  13. Updating Activity Records with additional data

    acalkins1957
    2 Attachment(s)
    • Replies: 1
    • Views: 1,272
    June7
    07-29-2014, 11:40 AM Go to last post

  14. Updating Field in Table2 with Table1 values based off matching criteria

    Prevost
    query, sql code, update query
    • Replies: 5
    • Views: 2,649
    Prevost
    07-29-2014, 11:20 AM Go to last post

  15. Append data from one query to another

    basabnanda
    query, query based on query
    • Replies: 7
    • Views: 2,019
    June7
    07-29-2014, 10:24 AM Go to last post

  16. Using Queries to sum times of similar types together

    radguy
    2 Attachment(s)
    • Replies: 1
    • Views: 1,147
    ranman256
    07-29-2014, 06:00 AM Go to last post

  17. Access Noob: Script Error Not Transfering Data from One Table to Another

    CPThompson
    • Replies: 3
    • Views: 1,831
    June7
    07-29-2014, 12:11 AM Go to last post

  18. finding the before sequence number

    Gilbert
    • Replies: 1
    • Views: 1,099
    June7
    07-28-2014, 04:56 PM Go to last post

  19. Adding fields to a database with data from another

    samdahlr
    • Replies: 8
    • Views: 1,024
    samdahlr
    07-28-2014, 02:23 PM Go to last post

  20. Insert Data from one table to another Query

    zipaway
    • Replies: 3
    • Views: 1,440
    pbaldy
    07-28-2014, 10:15 AM Go to last post

  21. Issue with LEFT JOIN

    Tortelloni
    • Replies: 9
    • Views: 1,678
    orange
    07-27-2014, 12:56 PM Go to last post

  22. Problem with SQL Syntax in VBA Update Query

    Phred
    • Replies: 1
    • Views: 1,092
    June7
    07-26-2014, 01:05 PM Go to last post

  23. Calculating fields using iif and checkbox value

    jree3000
    calulated field, iif function, query
    • Replies: 2
    • Views: 1,639
    jree3000
    07-26-2014, 12:05 PM Go to last post

  24. Search Query problem with nulls

    techtony
    • Replies: 3
    • Views: 805
    June7
    07-25-2014, 11:18 PM Go to last post

  25. How to delete the comma when multiple values are allowed

    AccessDanger
    • Replies: 8
    • Views: 1,901
    June7
    07-25-2014, 03:18 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