Resolutions on Queries

[niri77]

Query 1
SELECT Pl2008.*, Pl2008![Project] & "unique" & Pl2008![ID Code] AS PTUNID, Pl2008!Name & Pl2008![TYPE] AS NAMETYPE
FROM Pl2008;


Query 2
SELECT [Dl2008].*,[ZeroRate Resource Rate].Manager,
FROM [Dl2008] INNER JOIN [ZeroRate Resource Rate] ON [Dl2008].NAMETYPE = [ZeroRate Resource Rate].NAMETYPE;

I have two Queries

Query1(Dl2008) which runs on Table Named Pl2008 - All it does is pulls Infor from Pl2008 and concatenates and creates 2 concatenate columns

Query 2 which runs on Query 1(Dl2008) compares data from ZeroRate Resource Rate Table and Query Dl2008 using the concatenate value from Query 1 and match in Zerorate rate Table and populates values and creates new table in datasheet


Goal

Trying to find how could I combine both the Query so I do not have to do Query 1 first and then Query 2

Just to have one query.

Thanks in advance for guidance

 

[georgedwilkinson]

SELECT Pl2008.*,
Pl2008![Project] & "unique" & Pl2008![ID Code] AS PTUNID,
[ZeroRate Resource Rate].Manager
FROM
[Pl2008],
[ZeroRate Resource Rate]
WHERE
Pl2008!Name & Pl2008![TYPE] = [ZeroRate Resource Rate].NAMETYPE;

taken from your code. Comes "as is" off the top of my head. I did not troubleshoot it.

Don't remove the where clause or you'll get a cartesian product (that's bad).

 

[niri77]

it made my day !... Query worked perfectly fine... Thank you !!!

 

[georgedwilkinson]

That's really cool! I had my doubts since I didn't test it.

Glad to help.