View Single Post
  #1 (permalink)  
Old October 14th, 2005, 05:41 AM
ZArrinPour ZArrinPour is offline
Registered User
 
Join Date: Oct 2005
Location: , , .
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default Building Cross Query...

Hi all,
I want to create a Cross-Table or Cross-Query but i don't know
Where should i start with.?

Suppose we have a Table with following Specs:(only for test)

PID FID FName FValue
----- --- ---------- --------
108 2 Os Platform Windows XP Pro
108 3 Resolution 2400*4800 dpi
108 5 ScanAbility True
112 2 Os Platform Me, 98, 2000
112 3 Resolution 3200*6400 dpi
112 5 ScanAbility False
113
114
.....


As you might have already guessed,PID refer to Product Id and FID refer to
Field Id ,FName to FieldName and FValue to Field value.

Now I want to create a report like this:


---------------------------------------------------------------------
PID 108 112 113 114
---------------------------------------------------------------------
Os PlatForm Windows XP Pro Me, 98, 2000 ....
Resolution 2400*4800 dpi 3200*6400 dpi .....
ScanAbility True False

---------------------------------------------------------------------

Is it possible to creating such report.? if so,please help me.

Thanks in advance.
Regards.
Reply With Quote