Recent content by Nicesoni_ash

Hi, I have a query that returns me value in this format. # M1Rank GV-Q M1Rank GV-Q 1 CONS 99 CONS 2895 5 CONS 15 CONS 15 Now I want to make it show one more column in the end calculates what's the RANK and based on that rank, it...

I tried this union code, SELECT * FROM BONUS union SELECT * FROM [GV-Q];That almost did the trick but instead of two separate columns for each month for two different values, I have only one column for each month and two rows for each employee having these two different values. It's somewhat...

Can I use a union query or something like that?

How to do that in third query? Can you elaborate more please. I am trying to do the same with my own two crosstab queries, here is the link. If you could put some insight. www .access-programmers.co.uk/forums/showthread.php?t=253660

That link didn't help me. I am sorry but I am not familiar with SQL so I couldn't gather what that post implicates. To make matter easy, I have attached my database file along with the screenshots of what I desire, if you or anyone can have a look at suggest me what to do, I will be obliged...

I found an MS help topic for the same problem but that is also doing the same thing. It's based on a table that has static values, my table keeps updated every month http: //support. microsoft. com/kb/304458I Remove spaces please.

Hi I am trying to make a crosstab query to filter my records from my table. Here is the scenario. I want to make a query that will return me my Rep ID, Rep Name, his Bonus and his GV-Q (another value) based on every month. Now I make a crosstab query and here is the syntax. TRANSFORM...

Couldn't understand your example. Where it is explained we need to exclud these particular records?

Hi guys.. I am from India. I just recently started to learn Access. I done a basic course in office but that was about 10 years ago and everything is gone now from my mind. :-( Anyways I am here to learn it again as much as I can and hopefully can stay here for a long time.