J
Jack
I have the following query generated by an application as :
INSERT INTO tblExpense (eno, entrydate, contractedserviceexpense,
travelexpense, personnelexpense) VALUES('1', '04/26/2005', 11, 11, 11)
When I am pasting this code on sql window of a new query in access and run
it, then it does insert value in accordance with the query. However, when I
try to view it in the design view (GUI mode) it does not give the proper
design view. Rather it shows there is no table in the design view. I would
like any help on this.
Regards
INSERT INTO tblExpense (eno, entrydate, contractedserviceexpense,
travelexpense, personnelexpense) VALUES('1', '04/26/2005', 11, 11, 11)
When I am pasting this code on sql window of a new query in access and run
it, then it does insert value in accordance with the query. However, when I
try to view it in the design view (GUI mode) it does not give the proper
design view. Rather it shows there is no table in the design view. I would
like any help on this.
Regards