Hey knowitall, your version did the trick. The code I posted was the SQL view of a query I had in Access. I do have a question about...

I've made some changes, but I am still getting the errors highlighted in red

SELECT DISTINCT [server01/prod01].[ctsreports].rpt.tbloraclecustomers.[Account Number],

[server01/prod01].[ctsreports].rpt.tbloraclecustomers.[Customer Name],

[server01/prod01].[ctsreports].rpt.tbloraclecustomers.[Top Parent Customer Account] AS [Top Level],

[server01/prod01].[ctsreports].rpt.tbloraclecustomers_1.[Customer Name] AS [Top...

Is this the right syntax for "FROM server.database.schema.table alias":

"FROM [server01/prod01].[ctsreports].schema.rpt.tbloraclecustomers alias1"

What would the proper syntax be to point to that table?

I added the linked server addresses to the syntax. Code now looks like this:

SELECT DISTINCT [server01\prod01].[ctsreports].rpt.tbloraclecustomers.[Account Number], [server01\prod01].[ctsreports].rpt.tbloraclecustomers.[Customer Name], [server01\prod01].[ctsreports].rpt.tbloraclecustomers.[Top Parent Customer Account] AS [Top Level], [server01\prod01].[ctsreports].rpt.tbloraclecustomers_1.[Customer Name] AS...

Hi Paul,

Can you walk me through on how to have my target server point to my linked server? What would the query syntax me for this?

Cadavre,

Is the...

Hey Paul,

I am not making a separate table for each day. Just making a new version of the same table everyday and then "pasting" over the previous day's version

Hi Lowell,

This isn't a productiont table I am producing. It's a reference table that I use for research. I currently make the table in Access, but I would...