Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  nodelist  faq  login

Save yourself from the 'Gates' of hell, use Linux." -- like that one. -- The_Kind @ LinuxNet


computers / comp.databases.ms-access / latest

Re: Brainstorming Ideas (thread)

comp.databases.ms-access

Posted: 18 Days 13 Hours ago by: Ron Weiner

You 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

Re: Brainstorming Ideas (thread)

comp.databases.ms-access

Posted: 18 Days 13 Hours ago by: musicloverlch

Thanks 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

Re: Brainstorming Ideas (thread)

comp.databases.ms-access

Posted: 19 Days 17 Hours ago by: Ron Weiner

I 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

Brainstorming Ideas

comp.databases.ms-access

Posted: 19 Days 21 Hours ago by: musicloverlch

I 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.

rocksolid light 0.7.2
clearneti2ptor