Is there a way to order by COUNT like?:

New York 73,152

Chicago 34,152

Los Angeles 15,252

I'm using this as a learning exercise too, so if anyone has any PARTITION BY or WITH...

"ODBC--connection to CCE_Ethics_DB' failed."

Using "User" type DSN

Thanks Jonathan it worked!!

My problem is this part/count gives the correct figure of 4,090:

SELECT count(p.[peopleId]) AS 'Inactives'
FROM [BCC_DB].[dbo].[People] p

And this gives the correct figure of 2,126:

(SELECT count(p.[peopleId])...

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 6 years, 7 months ago by DaveBriCam.
• This reply was modified 6 years, 7 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, 10 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...