PDA

View Full Version : MUST it be a fight every time? To CREATE a VIEW:



mud2
04-09-2006, 11:31 AM
How to CREATE VIEW:?
Table LTable has Field1 containing names. HOW do I:
CREATE VIEW People (Field1) AS SELECT LTable.Field1 FROM LTable; ?
ACCESS Insists that there is an error in the CREATE TABLE !

I have tried several hindred permutations...

Norie
04-09-2006, 01:37 PM
mud2

This link (http://www.mcse.ms/archive152-2005-3-1513691.html) might interest you.