Query something like a crossstab

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there I have the following query

Sales PART QTY RATE CUST NAME VALID FROM_VALID_TO
NA VFD2 100 1.2 XYZ 20040923 20050403
NA VZX2 150 1.0 TEST 20040923 20050403
ETC

Is it possible to create a query that will put the valid from_valid to as
Column field and the row field underneat example,
20040923 20050403 20040923 20050403
NA NA
VFD2 VZXX
100 150
1.2 1.0
XYZ TEST
ETC

I was thinking something like a crosstab but didnt' seem to give me what I
want. Can anyone please provide any help feedback?
thank you,

Juan
 
Create a table that has the structure that you need. Then use Action
queries, like Delete, Append, and Update, to populate the table. This may
require doing several queries, not just one.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting
 
Hello Steve,
well my table structure is exactly as my query. If I understand you
correctly that means that the table I need would only have one field ? I was
hoping there was an easier way to do this. i'LL See what I can do thanks for
the info.

Juan
 
Create a NEW table, that will hold what the final structure needs to be.
Then, through a series of queries, I estimate about 3, run them to populate
the new table.

I think that you will need at least one crosstab, one append, and probably
an update query.too. Maybe a delete to empty the table everytime you need
to start over... so four.
 
Back
Top