Forum: Queries

Database query discussion.

  1. Duplicates in query need to NOT be suppressed

    GraeagleBill
    • Replies: 3
    • Views: 922
    pbaldy
    03-07-2017, 09:13 AM Go to last post

  2. Form based Parameter query, with criteria for two fields or none

    nocoffeenoworkee
    criteria, form, query 1 Attachment(s)
    • Replies: 6
    • Views: 1,394
    nocoffeenoworkee
    03-06-2017, 12:57 PM Go to last post

  3. How to auto-number rows for each unique record in a parent table

    ExtremeNovice
    • Replies: 7
    • Views: 2,258
    Bulzie
    03-06-2017, 08:43 AM Go to last post

  4. Query to count 3 components as one and show unique count

    aparnawangu
    • Replies: 1
    • Views: 1,382
    ranman256
    03-06-2017, 06:48 AM Go to last post

  5. Update query for each id

    giannirusso
    • Replies: 1
    • Views: 851
    ranman256
    03-05-2017, 07:12 PM Go to last post

  6. Running two queries from a single input parameter

    MLangendorf
    • Replies: 6
    • Views: 1,373
    pbaldy
    03-05-2017, 12:09 PM Go to last post

  7. Deleting records from a query

    banpreet
    • Replies: 1
    • Views: 948
    orange
    03-03-2017, 03:39 PM Go to last post

  8. How to determine if a record is the first in its set

    ExtremeNovice
    • Replies: 2
    • Views: 1,252
    ExtremeNovice
    03-03-2017, 03:18 PM Go to last post

  9. No Duplicates when Viewing Query

    zashaikh
    • Replies: 7
    • Views: 1,375
    aytee111
    03-03-2017, 03:06 PM Go to last post

  10. Extract specific text from very long string

    csmith
    2 Pages •
    1 2
    extract data, instr function, query 4 Attachment(s)
    • Replies: 24
    • Views: 4,284
    orange
    03-03-2017, 09:25 AM Go to last post

  11. How to reformat annual wages as hourly wages

    Ceichhorn
    • Replies: 2
    • Views: 1,068
    JoeM
    03-02-2017, 02:54 PM Go to last post

  12. Column Totals in a crosstab query

    mindbender
    • Replies: 8
    • Views: 1,393
    aytee111
    03-02-2017, 02:03 PM Go to last post

  13. Text and number

    adnancanada
    • Replies: 1
    • Views: 900
    RuralGuy
    03-02-2017, 01:08 PM Go to last post

  14. Using REPLACE Function for multiple character possibilities

    J Bhujanga
    • Replies: 11
    • Views: 2,690
    orange
    03-02-2017, 12:52 PM Go to last post

  15. Unhappy What is quicker way to retrieve data

    adnancanada
    • Replies: 14
    • Views: 3,155
    adnancanada
    03-02-2017, 09:46 AM Go to last post

  16. Query with Append

    jaykappy
    • Replies: 4
    • Views: 1,022
    jaykappy
    03-02-2017, 09:14 AM Go to last post

  17. Two left joins help

    goalnightx
    2 Pages •
    1 2
    join, left, table 7 Attachment(s)
    • Replies: 27
    • Views: 3,791
    aytee111
    03-01-2017, 07:10 PM Go to last post

  18. query with grouping and subqueries not working

    BillR
    queries. sql acesss, query, sub query
    • Replies: 3
    • Views: 966
    BillR
    03-01-2017, 04:59 PM Go to last post

  19. Question Multiply two fields from two different tables and update a field in one of them with the result

    3bgt650
    • Replies: 3
    • Views: 1,582
    3bgt650
    03-01-2017, 02:46 PM Go to last post

  20. Multiple control type Parameter Form used to filter Reports: Help with VBA Code

    Oblio
    combobox parameters, list box parameters, parameter form 2 Attachment(s)
    • Replies: 2
    • Views: 1,383
    Oblio
    03-01-2017, 01:48 PM Go to last post

  21. Query format questions!! Help!!

    jgrady
    • Replies: 4
    • Views: 952
    ranman256
    03-01-2017, 01:01 PM Go to last post

  22. Query Criteria that Checks if a Form is Open

    PeakH
    • Replies: 5
    • Views: 1,437
    aytee111
    02-28-2017, 04:23 PM Go to last post

  23. Update query works but not when called in a form

    agiuga
    • Replies: 4
    • Views: 1,422
    Micron
    02-28-2017, 10:25 AM Go to last post

  24. Find on;y records without a match

    Homegrownandy
    1 Attachment(s)
    • Replies: 3
    • Views: 1,015
    Homegrownandy
    02-28-2017, 03:37 AM Go to last post

  25. Trimming Internal Spaces from a String

    J Bhujanga
    • Replies: 2
    • Views: 1,202
    J Bhujanga
    02-27-2017, 04:51 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