Dynamic Field Name in Query By Date

On Fri, 21 May 2004 02:09:55 -0500, Sakuraki
wrote:


Any comments?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Yes; Duane and I both have replied with questions and concerns. Did
you not get the replies? (I'm not a user of ExcelTip.Com so I'm not
certain how replies end up getting back to you - hence I'm copying
this to EMail. Please reply to the newsgroup).

The two answers are copied below for your information.

===========
Is this a crosstab query? Do you really have fields with names like
this?

--
Duane Hookom
MS Access MVP
===========
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.
===========


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Thank you for your comments!

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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

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

--
Duane Hookom
MS Access MVP


"Sakuraki" wrote in message
...

Thank you for your comments!

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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/