Forum: Queries

Database query discussion.

  1. Exclamation How to write query in access using NOT IN

    rmayur
    • Replies: 2
    • Views: 1,073
    rmayur
    02-24-2015, 03:07 AM Go to last post

  2. Question Transform Data .. pls help!

    Toble
    transform, transpose
    • Replies: 14
    • Views: 2,894
    Toble
    02-23-2015, 05:34 PM Go to last post

  3. Question Update Query for changing uppercase to lowercase not working

    Phyllis622
    • Replies: 4
    • Views: 1,366
    Phyllis622
    02-23-2015, 03:55 PM Go to last post

  4. Search for unique sting in Select Query

    Ada01
    instr(), wildcards 1 Attachment(s)
    • Replies: 2
    • Views: 1,318
    Ada01
    02-23-2015, 12:48 PM Go to last post

  5. Lookup field Query

    hnhpak
    lookup query
    • Replies: 1
    • Views: 829
    rpeare
    02-23-2015, 09:38 AM Go to last post

  6. NOT printing certain fields in a report

    papabill
    • Replies: 2
    • Views: 1,065
    rpeare
    02-22-2015, 06:42 PM Go to last post

  7. Adding a Count function to current select statement

    johnson8809
    • Replies: 2
    • Views: 1,801
    johnson8809
    02-21-2015, 07:32 PM Go to last post

  8. Date was defined as a 'Literal'

    johnson8809
    • Replies: 2
    • Views: 1,161
    johnson8809
    02-21-2015, 06:02 PM Go to last post

  9. Summary Statistics

    carojasa
    1 Attachment(s)
    • Replies: 4
    • Views: 1,405
    orange
    02-21-2015, 11:56 AM Go to last post

  10. date parameters export in crosstab queries

    sk88
    • Replies: 3
    • Views: 1,391
    pbaldy
    02-20-2015, 02:17 PM Go to last post

  11. Trouble with Compound Query

    bxdobs
    • Replies: 3
    • Views: 1,503
    June7
    02-20-2015, 11:42 AM Go to last post

  12. Append query without duplicates using two id's

    sdel_nevo
    • Replies: 2
    • Views: 1,718
    sdel_nevo
    02-20-2015, 08:25 AM Go to last post

  13. Post Make Table Query a

    Dutchie
    • Replies: 2
    • Views: 900
    lfpm062010
    02-20-2015, 06:26 AM Go to last post

  14. Help creating a VBA recordset, Pulling the data I need into it, and placing them in VBA variables.

    Phred
    • Replies: 3
    • Views: 1,453
    Phred
    02-19-2015, 04:41 PM Go to last post

  15. Multiple IIf and Multiple Calculation in query

    Arnold
    • Replies: 5
    • Views: 1,231
    Arnold
    02-19-2015, 02:51 PM Go to last post

  16. Update Query Problem (Not an Updateable Query)

    McArthurGDM
    2 Attachment(s)
    • Replies: 6
    • Views: 1,955
    McArthurGDM
    02-19-2015, 11:25 AM Go to last post

  17. Allocating criteria to query with VBA

    gangel
    • Replies: 1
    • Views: 915
    NTC
    02-19-2015, 08:18 AM Go to last post

  18. How to prevent ambiguous outer joins error message

    craigugoretz
    error messages, outer join, query
    • Replies: 1
    • Views: 5,009
    NTC
    02-19-2015, 08:10 AM Go to last post

  19. Creating serial numbers for non-distinct records

    Remster
    • Replies: 4
    • Views: 857
    Remster
    02-19-2015, 06:09 AM Go to last post

  20. Query pulls duplicates

    TazoTazmaniac
    duplicate data, query, sql mutiple joins 1 Attachment(s)
    • Replies: 7
    • Views: 1,373
    TazoTazmaniac
    02-19-2015, 03:56 AM Go to last post

  21. Using INSERT INTO from external database

    Williams485
    • Replies: 6
    • Views: 1,960
    Williams485
    02-19-2015, 03:43 AM Go to last post

  22. Cool Finding Customers (table-1) without Tasks (table-2)

    fredfortsonsr
    • Replies: 3
    • Views: 1,262
    pbaldy
    02-18-2015, 07:31 PM Go to last post

  23. Return records with empty combobox value

    vincentsp
    • Replies: 2
    • Views: 1,349
    ssanfu
    02-18-2015, 04:41 PM Go to last post

  24. How to do SELECT from mutliple backend files ..

    edmscan
    • Replies: 8
    • Views: 1,547
    edmscan
    02-18-2015, 01:30 PM Go to last post

  25. Question Update Query Issue

    Voodeux2014
    2 Attachment(s)
    • Replies: 9
    • Views: 1,775
    pbaldy
    02-18-2015, 12: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