Recent content by niri77

Not sure if I have nailed this down... but had to break this in pieces to achieve the final goal Created a Query2 based on Not Equal Field of 'PTUNID' and Grouping the fields Used Query 2 Values and IIF Statement to have the Values populated in Query1 and have similar set like Final_PR_RPT...

tried using VBA but i donot know much in VBA so still struggling to find a way to do the above.

I have unique situation not sure how to achieve this in Query. For understanding I have attached mdb has following tables 'PR_RPT' 'SYS_RPT' 'TIME_RPT' Final_PR_RPT 'PR_RPT' and 'TIME_RPT' has unique ID called as 'PTUNID', My Final goal is Final_PR_RPT. I have created a Query1, which Look...

That was really interesting to see that Null could work on Left Join to give not equal to Values. Thanks a lot.It worked. Niri

I have Table as PL2008 and RPT2. Both tables have one column named PTUNID. My goal is to first Group, sum certain Columns in the PL2008 then match PTUNID from this Grouping to RPT2 Table's column PTUNID and then show the results which do not match. I have written following Qry but what really...

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

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...

What I am trying to do is to do concatenate when i pull the data rather do it by query because. If I just pull the data, then I do query to concatenate create another table then do all my other queries... so in a way i am trying to eliminate a step in between since i already need a concatenate...

I have created a Table Design Name Last Name ID Number NameID I import data from CSV xls file which has Columns of Name, Last Name, ID Number. What I want to achieve is while importing it should Concatenate Name and ID number and store in Name ID. I have searched it well but havent been able...

hello, In excel i used the following formula =IF(COUNTIF(U$2:U$900,U3)>1,"Duplicate","")on one field to find duplicate, but I cannot come up with similar formula on column fields in a table. Any guidance? Thank you in advance Niri

Thank you ! It worked perfectly fine.

hello, I have two columns Column A and Column B. Both column has either a numeric values or blank. I am trying to sum both columns Column A and Column B, but unable to get values in Sum Column C where either Column A or Column B has blank values. Can anyone suggest what I should do...