I don't know of a way, outside of using T-SQL, to do what you want. Inner joins cause records without matches to drop out of the result set, so...

This is slightly wrong

WHERE DXCD1 IN (IS NULL, '7140')

Try

WHERE DXCD1 IS NULL OR DXCD1 = '7140'

If you create a new database in Access, it won't have anything in it. So you create a connection to the SQL Server database, and then link to the...

If you can connect to the SQL database from Access, you can link to the tables/views in SQL Server and then run a bunch of MakeTable queries in Access. ...

I would use either a proper backup script or you could right-click the database, and choose Backup... from the menu. Just to make sure you didn't damage it when...

You could create a new instance of your database, make it read-only, and then report on that. If you don't need real-time data, then that's the easiest.

You could just do...

What you do is entirely up to you. Search the jobs in your area for both SQL Server and Oracle. Take the certification exams if that's what floats...

Jeff,

If you're gonna go there, why not go to Gila Monster's Howlers - Partitioning[/url] ?

Sounds like you need an outer join between Sales and Budget instead of an inner join. Post your query so we can see what you're dealing with.

I can't answer your question without some CREATE TABLE scripts. What table are the records related to Customer coming from?

I posted a basic pattern based on AdventureWorks because it's...

If you add /x:Macroname to the end of the execution path, then when the database opens it will call the macro Macroname, so you could have something like

DoCmd.RunSQL...

Application.Quit

inside your macro...

maybe like this?

SELECT *

FROM test_max m

INNER JOIN

(SELECT id

, MAX(date_created) AS LastDate

FROM test_max

GROUP BY id) lst

ON m.id=lst.id

AND m.date_created = lst.LastDate;

You may want to add your fields explicitly to your SELECT...

That's what the second query I posted does. NEWID() returns a random number so ordering by it and then doing a TOP returns a random set of records each time...

Shot in the dark, since we don't have answers to Phil's questions, but here's a guess. I built this using AdventureWorks2012

SELECT [Name] AS TerritoryName

, t.TerritoryID

, tc.CustomerID

, tc.AccountNumber

FROM Sales.SalesTerritory T

CROSS...

write a stored procedure and assign him execute permissions on it?