Forum: Queries

Database query discussion.

  1. Query returning all values instead of specified string

    School Boy Error
    2 Pages •
    1 2
    3 Attachment(s)
    • Replies: 19
    • Views: 3,260
    School Boy Error
    10-21-2017, 07:51 AM Go to last post

  2. IIF query puzzle

    DecaturLady
    query iif 2 Attachment(s)
    • Replies: 14
    • Views: 17,218
    pbaldy
    10-20-2017, 09:07 PM Go to last post

  3. Division by zero error

    MTSPEER
    • Replies: 3
    • Views: 1,957
    MTSPEER
    10-20-2017, 12:14 PM Go to last post

  4. Create a running total

    PRyan
    • Replies: 4
    • Views: 1,177
    PRyan
    10-20-2017, 02:07 AM Go to last post

  5. Calculating a field where its value depends on the same field of the previous row

    toni2oni
    calculated fields, sql
    • Replies: 13
    • Views: 1,934
    ArviLaanemets
    10-20-2017, 01:26 AM Go to last post

  6. Help request query for DB with teacher, year and school in Access 2007

    Pelato1980
    • Replies: 3
    • Views: 826
    Pelato1980
    10-19-2017, 11:08 AM Go to last post

  7. Convert SQL Server Syntax To Access Query Syntax

    chalupabatman
    • Replies: 1
    • Views: 1,898
    June7
    10-18-2017, 08:53 PM Go to last post

  8. Update With Group By

    jo15765
    • Replies: 1
    • Views: 644
    June7
    10-18-2017, 08:41 PM Go to last post

  9. Append & Delete query of single record from a form on relational tables

    AndyC121
    1 Attachment(s)
    • Replies: 3
    • Views: 1,705
    AndyC121
    10-18-2017, 04:01 AM Go to last post

  10. how to query based on nested criteria

    TLC
    query
    • Replies: 3
    • Views: 901
    June7
    10-18-2017, 03:15 AM Go to last post

  11. Query to add missing data

    nejenkins
    • Replies: 1
    • Views: 681
    June7
    10-17-2017, 03:02 PM Go to last post

  12. Making an Update Query to Mimic an Excel IF Formula that Compares Two Columns

    spreestr
    • Replies: 2
    • Views: 851
    spreestr
    10-17-2017, 12:00 PM Go to last post

  13. Forcing a zero where value is null

    Dave_D
    • Replies: 4
    • Views: 947
    JoeM
    10-17-2017, 06:04 AM Go to last post

  14. Searching a table based on multiple fields

    sam1603
    • Replies: 1
    • Views: 883
    ranman256
    10-17-2017, 04:48 AM Go to last post

  15. Combo Box causes Append Query to Store Wrong Date in Table

    michael_bsog
    append, combo box, mail merge
    • Replies: 2
    • Views: 1,052
    Micron
    10-16-2017, 06:47 PM Go to last post

  16. Question Convert Customs System Date or Normal Date MM/DD/YYYY

    laniebe
    • Replies: 3
    • Views: 1,279
    laniebe
    10-16-2017, 11:47 AM Go to last post

  17. Queries using"is not null" in 4 different fields

    SummerCampGuy
    • Replies: 2
    • Views: 789
    SummerCampGuy
    10-13-2017, 08:51 AM Go to last post

  18. Access Date query with other criteria

    Bennie Beamer
    • Replies: 3
    • Views: 863
    pbaldy
    10-12-2017, 08:56 PM Go to last post

  19. Append Query to copy data to more that one table

    dinsey90
    append query, form append query, record automation 6 Attachment(s)
    • Replies: 11
    • Views: 1,993
    aytee111
    10-12-2017, 07:14 AM Go to last post

  20. Query Sum of quantity’s for different products per customer/store

    dennisb82
    3 Attachment(s)
    • Replies: 12
    • Views: 2,157
    dennisb82
    10-12-2017, 02:55 AM Go to last post

  21. Calculate percentages in query

    delmaruser
    • Replies: 3
    • Views: 789
    alansidman
    10-11-2017, 03:19 PM Go to last post

  22. How to Retrieve Customer's Previous Balance

    Athar Khan
    • Replies: 2
    • Views: 868
    June7
    10-11-2017, 12:52 PM Go to last post

  23. Using checkboxes on a continuous form to export data to a query

    myates
    • Replies: 5
    • Views: 1,086
    myates
    10-11-2017, 08:15 AM Go to last post

  24. Calculating variance between two dates and converting result to qty of hours

    rfigueroa1976
    • Replies: 6
    • Views: 1,066
    aytee111
    10-10-2017, 02:27 PM Go to last post

  25. Splitting Data

    Ray67
    • Replies: 6
    • Views: 999
    JoeM
    10-10-2017, 11:17 AM 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