Hello everyone,
I have two database: A and B.
Database "A" has all the forms and database "B" has some query and tables that are linked to "A".
My question is: I have a query that referance a field from a form in database "A". How do I write that statement in my query?
For example;
Query in Database "B":
SELECT tblPreferred.Policy,
tblPreferred.SharesPurchased,
tblPreferred.PurchaseDate,
tblPreferred.Amount,
tblPreferred.SharePrice,
tblTransactions.TransactionDescription AS [ Transaction ],
tblPreferred.ID
FROM tblPreferred
INNERJOIN tblTransactions
ON tblPreferred.TransactionType = tblTransactions.TransactionID
WHERE(((tblPreferred.PurchaseDate)Between [Forms]![frmReports]![txtStatementFrom ] And [Forms]![frmReports]![txtStatementTo]));
This field is coming from database "A" but how do I referance database "A"?
[Forms]![frmReports]![txtStatementTo]
Please Help.
Thanks
Leo
I have two database: A and B.
Database "A" has all the forms and database "B" has some query and tables that are linked to "A".
My question is: I have a query that referance a field from a form in database "A". How do I write that statement in my query?
For example;
Query in Database "B":
SELECT tblPreferred.Policy,
tblPreferred.SharesPurchased,
tblPreferred.PurchaseDate,
tblPreferred.Amount,
tblPreferred.SharePrice,
tblTransactions.TransactionDescription AS [ Transaction ],
tblPreferred.ID
FROM tblPreferred
INNERJOIN tblTransactions
ON tblPreferred.TransactionType = tblTransactions.TransactionID
WHERE(((tblPreferred.PurchaseDate)Between [Forms]![frmReports]![txtStatementFrom ] And [Forms]![frmReports]![txtStatementTo]));
This field is coming from database "A" but how do I referance database "A"?
[Forms]![frmReports]![txtStatementTo]
Please Help.
Thanks
Leo