that worked thanks!

Here's what I'm using in Access to insert a record:

Private Sub cmdSave_Click()

Dim strCUser As String
strCUser = CurrentUserName
Dim con As adodb.Connection
Dim cmd As adodb.Command
Dim rs As adodb.Recordset

Set con...

• This reply was modified 5 years, 11 months ago by DaveBriCam.
• This reply was modified 5 years, 11 months ago by DaveBriCam.

Thanks all... works perfectly now!

Actually this compiles but I need to have "OriginalDatabaseID" returned as text rather than number:

CREATE VIEW [dbo].[GCDFview]
AS

SELECT p.FirstName, p.LastName, c.city, p.instructorInt as 'Instructor'
, s.stateAbbrveation AS 'State', 'USA'...

• This reply was modified 6 years, 2 months ago by DaveBriCam.

Like this? The compiler is throwing an error on one of the "=" signs:

SELECT p.FirstName, p.LastName, c.city,
OriginalDatabaseId = iif(InstructorInt = -1,-1,p.PeopleId), 
s.stateAbbrveation AS 'State', 'USA' AS Country,...

Thank you... works perfectly!

I'm using SQL Server but got mixed up as the database has an Access frontend which uses Now().

That works perfectly... thanks for the help!

The below works except it doesn't label each total:

SELECT [Actives] FROM [GCDF_DB].[dbo].[vTotalActives] as "Actives GCDF"
UNION ALL
SELECT [Actives] FROM [ACS_DB].[dbo].[vTotalActives] as "Actives ACS"
UNION ALL
SELECT [Actives] FROM [BCC_DB].[dbo].[vTotalActives] as...