FAO [MVP] S. Clark

[James]

Many Thanks for that.

I think its me being thick I have tried this UNISON thing
and its not working. I dont know why not I must be doing
it wrong. So I looked in the Access help for it and I
cannot find it.

Would you like to explain about it a little or would you
like a look at the database?

Many Thanks fro all this

James

 

[[MVP] S. Clark]

The word was probably UNION.

(If I wrote UNISON, then I dearly apologize for the typo.)

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[James]

Cheers I will look for that... he he he no wonder I
could not find it

James

P.S. If I have any problems can I get back to you?

 

[James]

Hello I have done this:

SELECT Forname,Surname,Location,Department,Usename,
Password, "Type of Dialin" FROM [SQT Live CISCO Accounts];
UNION ALL
SELECT Name,Base,NULL,NULL,Username,Password,"Type of
Dialin" FROM [live CISCO Accounts];

And its asking me for a Username???

Why is it doing this and if I fill one in then it creates
an extra field with the username I put in the prompt box.

James