If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Dynamic Field Name in Query By Date
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/ |
#3
|
|||
|
|||
Dynamic Field Name in Query By Date
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/ |
Thread Tools | |
Display Modes | |
|
|