Strange problem with query

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
 
J

John Nurick

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top