Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: susieqtotallynew
  • Order by date
  1. susieqtotallynew

    Query Assistance

    They share an ID number.
  2. susieqtotallynew

    Query Assistance

    Hi, all, I'm hoping you'll help me now as you have before. I have two tables--table A and table B. Table A has information that exists in a current database. Table B has information that may be used to update the information in the current database. In some cases, information in a field in...
  3. susieqtotallynew

    Word Merge Substitute for Ugly Abbreviations

    Hi, all, I am working with Word 2007 mail merge document. The data source used for the document has some "ugly" abbreviations, such as 10ACP, etc., that are necessary to the database that feeds the merge document. Is there a way to automatically change the 10ACP to 2010 Annual Campaign (or...
  4. susieqtotallynew

    Access Runtime Version Connect to Different Data Sources

    I am planning to deploy a runtime Access database. The application will be distributed to different organizations. The primary use of the application is to connect to and report on a SQL server database on the backend. Though each organization has the same SQL database, it has a different...
  5. susieqtotallynew

    Getting the Quote Marks right....

    I think you misunderstand. This is used to create a SQL statement, in which the WHERE clause is a necessary component.
  6. susieqtotallynew

    Getting the Quote Marks right....

    When I use the following Where = Where & " AND [Class Year] Between '" & Me![Class Year] & "' And '" & Me![Class Year 2] & "' " and do not enter anything into the class year or class year 2 fields, the query formats as follows: Between '' And '' I would like for NOTHING to show up if there is...
  7. susieqtotallynew

    Getting the Quote Marks right....

    Hi, all, The following line of VB code is supposed to concatenate fields to create a sql string: Where = Where & " AND [Year] Between + Me![Year] + And " ""+ Me![Year 2] +"" Year and Year 2 are text fields. I keep getting errors associated with the quotation marks. Can someone let me...
  8. susieqtotallynew

    VB in Access Query

    Duane, Thanks very much. That is all working fine... Now, if I may throw a fly in the ointment, so to speak...How would I fix up the line to accommodate a range of values? For example, I have a field in the database called "Ask Amount" and would like to find values that range between a lower...
  9. susieqtotallynew

    VB in Access Query

    Duane, Sorry if I'm being obtuse, but using your code, I now get an error on the following line: qd.SQL = strSelect & strWhere saying, specifically, that the variant is empty. Perhaps it would help if you could explain what these two lines do: strSelect = "SELECT ... FROM .... " where...
  10. susieqtotallynew

    VB in Access Query

    Hi, all, In my access database, I am using a form to allow users to enter parameters for ID, Constituency Type and Class Year. The command button on the form runs the following VB code: Private Sub RunQuery_Click() Dim db As DAO.Database Dim QD As QueryDef Dim where As Variant Set db =...
  11. susieqtotallynew

    Converting User-Friendly parameters to access parameter

    I am using a form to query a table in an Access database. The item being queried on the table would have a value of "Y" or "N" (meaning yes or no). On the user end, I would like to display the choices available to them in a drop down as "Yes" or "No" and then translate this to 'Y' or 'N' for...
  12. susieqtotallynew

    SQL to Choose First Item Meeting Criteria

    Markros, I need to be able to select (for example), 3, and if no 3, then 2, and if no 2 then 1. Could you explain some of your shorthand a bit? I'm not familiar with the expression ;with cte and 1[/code Thanks, Susan
  13. susieqtotallynew

    SQL to Choose First Item Meeting Criteria

    I am working with a MS SQL database. The database stores various names for constituents. Each constituent can have multiple name types. Each name type is assigned an ID number. For example, I might have an individual name type, assigned name_type_ID 1. I may also have a joint name type...
  14. susieqtotallynew

    Auto Increment Field Using VB?

    Skip, Thanks for your help with my questions. I appreciate it. Susan
  15. susieqtotallynew

    Auto Increment Field Using VB?

    Again, I am likely being obtuse, but I have only two columns to work with in the table. One is date, the other is ID. One ID may have many dates. Each ID/Date Listing needs a unique number. In this scenario, which column is Col1?
  16. susieqtotallynew

    Auto Increment Field Using VB?

    I'm not sure I understand your question...It's a query created in an access database...SQL...
  17. susieqtotallynew

    Auto Increment Field Using VB?

    Good day, all, I have created a query based on an Access Database. I would like to add a numeric field to the query results that automatically increments each item in the results list. Result 1 would have value of 1, result 2 value of 2, etc. It has to be an "automated" solution, meaning that...
  18. susieqtotallynew

    Help with Table Aliases (?)

    Of course. ID AddTypeID AddType Add AddTypeID2 AddType2 Add2 1 2 Home 123 Lemon St. 5 Work 456 Drop St.
  19. susieqtotallynew

    Help with Table Aliases (?)

    Should have clarified a bit...I'm hoping to list this on ONE line. Thanks again...May not be do-able? You all are a treasure!
  20. susieqtotallynew

    Auto-truncate subreport

    Oh, goodness...I have yet another question. It's making me feel SO stupid... I have a query that lists the last x transactions for a participant. In some cases, this may be 1 transaction. In others, 50 transactions, and in still others, 0 transactions. In my access report, I am using a...

Part and Inventory Search

Back
Top