Search results

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

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

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

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

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