Search results for query: *

They share an ID number.

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...

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...

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...

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

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...

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...

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...

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...

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 =...

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...

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

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...

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

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?

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

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...

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

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!

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...