Hi,
Someone please tell me that variables can be used in SQL statements? Is there any possible way?
Heres the SQL:
SELECT [Equipment Docs 1].EQ_COMPONENT_TAG, ORSUSR_TIDECDRW.DOCUMENT_TYPE, ORSUSR_TIDECDRW.DOCUMENT_SUB_TYPE, ORSUSR_TIDECDRW.DOCUMENT_NBR, ORSUSR_TIDECDRW.DOC_SHEET_NBR, Null AS Action, Null AS [Action Note] INTO [Equipment Docs Temp]
FROM [Equipment Docs 1] INNER JOIN ORSUSR_TIDECDRW ON [Equipment Docs 1].oc = ORSUSR_TIDECDRW.OWNER_CODE_50;
for the INTO clause I want to be able to specify,
INTO [Equipment Docs Temp] & [Forms]![Form - Change Record]![Subform Admin].[Form]![ChangeID];
Is this possible?
(The reason is I have a make table query that runs before a form is open - bound to that temp table. Then after the user inputs/modifies in that form, I run anappend query, appending the changes to the Master table. I want to make sure the above make table query makes a table with a different name every time so two different users dont corrupt each others temp data.)
[This message has been edited by wrek (edited 08-09-2001).]
Someone please tell me that variables can be used in SQL statements? Is there any possible way?
Heres the SQL:
SELECT [Equipment Docs 1].EQ_COMPONENT_TAG, ORSUSR_TIDECDRW.DOCUMENT_TYPE, ORSUSR_TIDECDRW.DOCUMENT_SUB_TYPE, ORSUSR_TIDECDRW.DOCUMENT_NBR, ORSUSR_TIDECDRW.DOC_SHEET_NBR, Null AS Action, Null AS [Action Note] INTO [Equipment Docs Temp]
FROM [Equipment Docs 1] INNER JOIN ORSUSR_TIDECDRW ON [Equipment Docs 1].oc = ORSUSR_TIDECDRW.OWNER_CODE_50;
for the INTO clause I want to be able to specify,
INTO [Equipment Docs Temp] & [Forms]![Form - Change Record]![Subform Admin].[Form]![ChangeID];
Is this possible?
(The reason is I have a make table query that runs before a form is open - bound to that temp table. Then after the user inputs/modifies in that form, I run anappend query, appending the changes to the Master table. I want to make sure the above make table query makes a table with a different name every time so two different users dont corrupt each others temp data.)
[This message has been edited by wrek (edited 08-09-2001).]