Answer / ruchi

A PIVOT TABLE ALLOWS US TO REORGANIZE AND SUMMARIZE
SELECTED COLUMNS AND ROWS OF DATA IN A SREADSHEET.

Answer / prasanna s chitale

HI, GUYS

PIVOT TABLE IS ADVANCE FEATURE BY SQL ANSI WITH TRANSFORM
STATEMENT. THIS REPRESENTING THE DATA IN CONSOLIDATE WAY.
FOR EXAMPLE IF WE WANT THE PRODUCT V/S MONTHLY SALE ANALYSIS
THEN IT IS POSSIBLE WITH PIVOT TABLE.

MONTH APRIL-07 MAY-07 JUN-07
PRODUCT
MARUTI-800 700 800 550
MARUTI ZEN 100 120 90

ETC

THIS IS TYPICAL PIVOT TABLE

What is ODBC?

1 Answers  

---

Is it posible to Create Tables Through Querydef?

0 Answers  

---

How do I mimic a toggle button?

0 Answers  

---

Types of cursors in DAO?

0 Answers  

---

by writing MACRO CODE,i want to retrive data from one spead sheet to another UI (workbook). control will search cell by cell for each row and load the data in another workbook(UI). ex: custdetails custname lastname locaton mobile pincode custdetails raj tony hyd 555555 521245 servcreqrd srvce# srvcename location srvcepincode servcreqrd 754 drilling hyd 521784 for the above example in the another workbook retrive data like this custname Raj srvce# 754 srvcepincode 521784. while retrieving data control will search cell by cell for each row.

0 Answers   Infotech,

---

Which datatypes in Visual Basic are capable of accepting Nulls?

1 Answers  

---

Is it possible to Access BackEnd procedures?

0 Answers  

---

What is RDO?

1 Answers  

---

Explain about control properties?

0 Answers  

---

What is Implicit?

1 Answers  

---

How many ways we can access file using VB?

0 Answers  

---

How would you navigate between one document to another document

0 Answers  

---