Welcome to novaBBS (click a section below)
|mail  files  register  nodelist  faq  login|
Posted: 18 Days 13 Hours ago by: Ron WeinerYou can make Dynamic crosstabs in code by creating the Sql for them on the fly. Build a form that asks your users to choose the tasks they are interested in and the Dates to be included. Then make a Sql statement in code and execute
Posted: 18 Days 13 Hours ago by: musicloverlchThanks for your input. I don't have an aversion to crosstab queries, I just need them to be dynamic. I don't know how many tasks would be listed so it's hard to make a fixed crosstab. I tried making it dynamic, but the column headings we
Posted: 19 Days 17 Hours ago by: Ron WeinerI dont understand your adversion to Crosstab queries. The Sql syntax that Access uses is pretty spiffy, and far easier to implement than the Sql Server version. You should be able to limit the number of columns by including the only t
Posted: 19 Days 21 Hours ago by: musicloverlchI might not explain this correctly, but I want to see if you have any solutions to my problem. I would like to create a table that had the following fields ID(autonumber) TaskSection (string) TaskName (String) CompleteDate (date) Then th
4 recent articles found.