Microsoft access sql query variable

Join Us! By joining you are opting in to receive e-mail. Promoting, selling, recruiting, coursework and thesis posting is forbidden. Students Click Here. Hello Tek-Tips and thank you again for taking the time to read my question. I am generating a SQL statement which uses 4 dates as parameters.

However these 4 dates are needed several times in the SQL statement. Instead of using a question mark for each one of them, can I declare a variable in the Select statement, assign this variable, and use it in the SQL code? I want to be able to assign Date1 and Date2 through my code.

Does Access allow for this? Any suggestions are greatly appreciated. Tom maxflitom. SkipVought, Thank you for responding. This is low priority for them. I want to use the deptnum field as my criteria in the sql query that's pulls the data from the oracle db. I suspect you need to create a passthrough query that Access will hand to the Oracle data engine to run. You probably don't need an Oracle DBA to do this though it might help , but you at least need to post the relevant table and fieldnames to let us help you construct the query.

There's nothing we volunteers can do to help without more information! DeptNum and send all matching records to an access table or perhaps a csv file if there are too many records for a table. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.

Note: For the purposes of a union query, the Number and Text data types are compatible. When you use the UNION operator, you can also specify whether the query results should include duplicate rows, if any exist, by using the ALL key word. For example, suppose that you have a table named Products and another table named Services. Both tables have fields that contain the name of the product or service, the price, warranty or guarantee availability, and whether you offer the product or service exclusively.

Although the Products table stores warranty information, and the Services table stores guarantee information, the basic information is the same whether a particular product or service includes a promise of quality. You can use a union query, such as the following, to combine the four fields from the two tables:. SQL syntax. Access SQL: basic concepts, vocabulary, and syntax. Notes: Access ignores line breaks in a SQL statement. Need more help? Expand your skills. Get new features first.

Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Also, the query will be run from a. If you are running from a Net app you can Add Parameters. I don't think it is possible to use as a prefix for parameter names in Access. Removing the seemed to me to cloud the issue, especially as it will not break anything. If you paste the above two lines into the query design window, the ampersand in the parameter name is removed on save and int is changed to long, but it will run on paste.

Similary, if you use the lines as the basis of a querydef, the query will execute. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.