Search results

Here is the original query to be specific SELECT DISTINCT FTE.[A], FTE.[B], FTE.[C], FTE.[D], FTE.[E], FTE.[ProJECT CODE], FTE.[F], FTE.[G], Sum(FTE.APRIL) AS [Sum Of APRIL], Sum(FTE.MAY) AS [Sum Of MAY], Sum(FTE.JUNE) AS [Sum Of JUNE], Sum(FTE.Total) AS [Sum Of Total] FROM FTE LEFT JOIN [PDR...

Sorry, You got 'group by' clause right. Regarding cartesian join, How can I avoid it when I want to fetch 2 fields from 2 different tables in one query ?

Cartesian Join: Result changing when tables added to FROM Hello Friends, Below are 2 quries, both are same with only difference is added table in FROM SELECT [TableA].Storename, Sum([TableA].[Sum Of Total]) AS [SumOfSum Of Total], Sum([TableA].[Sum Of Q1 Revenue]) AS [SumOfSum Of Q1 Revenue]...

Thank you very much for providing your valuable guidance. Your answers are helping me a lot in connecting missing dots. :) I have stored 4 excel files in one folder. The data in all 4 excel will be updated daily. I will refresh those 'linked tables' manually everyday. Now will the queries pick...

Fortunately, I have managed to do all my calculations in access :) . I have designed queries and reports. Now I wanted to update all my data in excel and wants access to run queries and generate reports daily automatically.

I wanted to say I use 'design view', which is alternative to writing SQL. If lets say 2GB is the limit and daily my report size is 20MB. So Can I only store only 100 reports or can somehow extend it?

Hi Team, I am a new guy to access. We are planning to shift all excel reports to MS Access. We have created a big excel template with around 15 tabs which calculates daily sales generated as summary. We manually copy-paste data in each different tabs, which then calculates required fields...

It is throwing some chinese characters(ᑺꮮ䁳) instead of value for 'Salary1'.

As of now I am running all queries and rate from them by using code I mentioned above. But I know that I am getting my 70% Rates from first query itself. I just want to run other queries for those 30%. In excel, we used to set a flag for null and run the vlookup if flag is positive. Can...

Hello Friends, I am trying build a logic for running queries if specific condition is met. Basically I have a database of 5000 contractors for which I want to calculate rate. There is a 'Rate table' which have rates for 70% people but not for all. So I am calculating rates for rest of people...

But this code is throwing error that aggregate function not allowed in the end.

Hello Friends, I facing problem while calculating a new field. I want to calculate a new field M4 which is --> 19* [SUM OF M1] This 'SUM OF M1' is summary of M1 field. Though its already present access is again asking me by throwing 'ENTER PARAMETER VALUE: SUM OF M1' Help is much appreciated.

I want to merge first 5 columns as they are similar. Last 6th one Salary0 & Salary1 are different. Query0 - A | B | C | D | E | Salary0 Query1 - A | B | C | D | E | Salary1 Answer should be - A | B | C | D | E | Salary0 | Salary1 But its showing A | B | C | D | E | Salary0 with Salary1...

I am facing a issue in Union query. I am trying to merge 2 query results. Both results have 6 columns. Last column is 'Salary0' in 1st query and 'Salary1' in 2nd query. But after union, both are columns are getting merged under header of 'Salary0'. I want both to remain as separate columns...

I have connected a live excel to the database. We are blending all the data by suing query. Once all fields are ready, we will create table.

we are moving all data from excel to access. SO need help in designing query as mentioned above.

I am working on a project of excel transformation. In excel we have columns Emp Id (A), Project Id (B), Project Role (C ), Location (D) and Salary. We have salary almost all a employees. But for those we do not have we calculate salary taking average of B,C,D / C,D / D. We want only one salary...