Forum: Queries

Database query discussion.

  1. Counting Text Fields in a Query

    TimMoffy
    2 Attachment(s)
    • Replies: 2
    • Views: 1,332
    TimMoffy
    05-14-2012, 08:00 AM Go to last post

  2. Append query creating duplicates

    dhicks19
    1 Attachment(s)
    • Replies: 1
    • Views: 1,587
    ssanfu
    05-14-2012, 06:36 AM Go to last post

  3. New to Access - Multiple rows/records into 1 row & several columns - HELP!

    weslake77
    • Replies: 1
    • Views: 3,125
    June7
    05-14-2012, 04:12 AM Go to last post

  4. Smile Changing the century part of the date.

    Chet
    • Replies: 2
    • Views: 1,218
    Chet
    05-13-2012, 08:27 PM Go to last post

  5. Adding together the results of calculations in previous columns

    MichealShinn
    • Replies: 6
    • Views: 2,008
    ssanfu
    05-12-2012, 03:13 AM Go to last post

  6. Querying on Active & Deactivation Dates

    ClawGee
    • Replies: 10
    • Views: 1,454
    June7
    05-11-2012, 05:35 PM Go to last post

  7. Select the last price in a day

    12345678
    • Replies: 1
    • Views: 1,743
    Bob Fitz
    05-11-2012, 02:08 PM Go to last post

  8. Invoice Query

    Analogkid
    invoice, new database, query 2 Attachment(s)
    • Replies: 7
    • Views: 1,711
    Analogkid
    05-11-2012, 10:41 AM Go to last post

  9. Querying 2 or more tables

    NewbieInCT
    multiple queries, partial word search, query 2 or more tables 1 Attachment(s)
    • Replies: 12
    • Views: 2,376
    jzwp11
    05-11-2012, 09:49 AM Go to last post

  10. Help with Update query: updating one table based on data selected from another table?

    mjblay
    • Replies: 6
    • Views: 13,249
    mjblay
    05-10-2012, 08:20 PM Go to last post

  11. Nested And/Or query

    kagoodwin13
    • Replies: 2
    • Views: 1,314
    pbaldy
    05-10-2012, 12:10 PM Go to last post

  12. Simple Query for multiple ands

    Lorlai
    • Replies: 8
    • Views: 1,399
    orange
    05-10-2012, 11:18 AM Go to last post

  13. Help with a small query

    Datech
    • Replies: 4
    • Views: 1,467
    orange
    05-10-2012, 09:14 AM Go to last post

  14. Some Sub Query Help....?

    djclntn
    4 Attachment(s)
    • Replies: 9
    • Views: 1,087
    orange
    05-10-2012, 05:43 AM Go to last post

  15. Database help, key violations

    dhicks19
    3 Attachment(s)
    • Replies: 6
    • Views: 1,813
    dhicks19
    05-10-2012, 05:06 AM Go to last post

  16. Update number field

    TinaCa
    invoice id, update number field, update query 1 Attachment(s)
    • Replies: 3
    • Views: 849
    jzwp11
    05-09-2012, 09:14 PM Go to last post

  17. Wink Running a Parameter Query

    ELW
    2 Attachment(s)
    • Replies: 4
    • Views: 856
    ELW
    05-09-2012, 08:06 PM Go to last post

  18. Calculating the Total of Average Fields

    DDEB
    • Replies: 1
    • Views: 1,193
    June7
    05-09-2012, 06:26 PM Go to last post

  19. Need Help on Query for Orders. 90% Done just cant figure out the last part.

    grippy
    • Replies: 3
    • Views: 1,274
    TinaCa
    05-09-2012, 05:27 PM Go to last post

  20. A query with Sum() and how to add more fields to it.

    sepoto
    field, query, sum
    • Replies: 3
    • Views: 841
    pbaldy
    05-09-2012, 04:49 PM Go to last post

  21. Convert Values in Field to another VALUE? EX: W785 = 7785 due to W = 7

    taimysho0
    • Replies: 7
    • Views: 1,815
    June7
    05-09-2012, 01:55 PM Go to last post

  22. Separating Date and Time into Two Input Fields

    Chris1112
    date time
    • Replies: 8
    • Views: 2,933
    Chris1112
    05-09-2012, 08:28 AM Go to last post

  23. One MS Access Query - Multiple Averages?

    ajcke
    • Replies: 9
    • Views: 2,309
    Robeen
    05-09-2012, 07:16 AM Go to last post

  24. Query to show averages by month

    DDEB
    • Replies: 3
    • Views: 2,377
    June7
    05-08-2012, 05:11 PM Go to last post

  25. Add "00" to the front of all the values in my column???

    taimysho0
    • Replies: 3
    • Views: 1,220
    taimysho0
    05-08-2012, 05:01 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