Dynamic Field Name in Query By Date

S

Sakuraki

Hi to all Masters,

I have Order Qty for past 30 days (04/01 to 04/30), I want the fiel
name display by date, is it possible?

Original field name

OrdQtyDay1, OrdQtyDay2, ....... OrdQtyDay30

Wanted field name

OrdQty04/01, OrdQty04/02, OrdQty04/03.......OrdQty04/30


is it possible
 
J

John Vinson

Hi to all Masters,

I have Order Qty for past 30 days (04/01 to 04/30), I want the field
name display by date, is it possible?

Original field name

OrdQtyDay1, OrdQtyDay2, ....... OrdQtyDay30

Wanted field name

OrdQty04/01, OrdQty04/02, OrdQty04/03.......OrdQty04/30


is it possible?

With difficulty - but it would CERTAINLY be a VERY BAD IDEA.

Storing data in fieldnames is never good design. If you have a table
with the fields named above *it is incorrectly normalized*! Much
better would be a two-field table with the orderdate in a Date/Time
field and the Quantity in a numeric field, plus any other fields (such
as who is doing the ordering, or who the order is for).

You could then create a Crosstab query to get the dates across the top
and the quantities in (one or more) rows.
 
S

Sakuraki

Thank you for your comments!

But I know nothing about crosstab query.. Can anyone of you guide me o
show me any good website that I can learn about it
 
D

Duane Hookom

You should provide some actual field names and records. Also, provide the
desired output/display of your data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top