Strange problem with query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Some kinds of queries cannot be represented in the query design window,
and this is one of them. Also, remember that the upper part of the
window shows a query's source table(s), and that this query doesn't have
a source table.
 
Back
Top