Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

Multics is security spelled sideways.


devel / comp.databases.ms-access / Re: Brainstorming Ideas

SubjectAuthor
* Brainstorming Ideasmusicloverlch
`* Re: Brainstorming IdeasRon Weiner
 `* Re: Brainstorming Ideasmusicloverlch
  `- Re: Brainstorming IdeasRon Weiner

1
Brainstorming Ideas

<bd33d576-4c93-48b0-a72b-fce6ab948ae6n@googlegroups.com>

 copy mid

https://www.novabbs.com/devel/article-flat.php?id=561&group=comp.databases.ms-access#561

 copy link   Newsgroups: comp.databases.ms-access
X-Received: by 2002:a05:6214:27e4:b0:45a:a04d:d835 with SMTP id jt4-20020a05621427e400b0045aa04dd835mr4785976qvb.82.1651601286916;
Tue, 03 May 2022 11:08:06 -0700 (PDT)
X-Received: by 2002:a05:6870:4624:b0:ed:977b:7842 with SMTP id
z36-20020a056870462400b000ed977b7842mr2334327oao.89.1651601286554; Tue, 03
May 2022 11:08:06 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ms-access
Date: Tue, 3 May 2022 11:08:06 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=2601:2c7:8c00:17f0:29b1:89e0:c6a9:32d0;
posting-account=Lr72qQoAAADkUv-gyUq0hiLVTj6vT-m8
NNTP-Posting-Host: 2601:2c7:8c00:17f0:29b1:89e0:c6a9:32d0
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <bd33d576-4c93-48b0-a72b-fce6ab948ae6n@googlegroups.com>
Subject: Brainstorming Ideas
From: lho...@gmail.com (musicloverlch)
Injection-Date: Tue, 03 May 2022 18:08:06 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 25
 by: musicloverlch - Tue, 3 May 2022 18:08 UTC

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 the table would have fields like
Task Section TaskName CompleteDate
Census Email Sent 1/1/2022
Census Census Received 1/5/2022
Census Financials Received 1/7/2022

The goal is for the user to be able to add however many tasks they want without me needing to be involved.

My problem is that I would then need to make a view where they could see all the tasks horizontally. The tasks might change so I can't put a fixed list in the crosstab query.

I really want to do this because I'm sick of having to add fields every time they want to track some new date, but I can't figure out how to overcome the crosstab problem.

Thoughts? TIA

Laura

Re: Brainstorming Ideas

<t4s7pm$72p$1@dont-email.me>

 copy mid

https://www.novabbs.com/devel/article-flat.php?id=562&group=comp.databases.ms-access#562

 copy link   Newsgroups: comp.databases.ms-access
Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: rw...@domain.com (Ron Weiner)
Newsgroups: comp.databases.ms-access
Subject: Re: Brainstorming Ideas
Date: Tue, 03 May 2022 17:45:24 -0400
Organization: WorksRite
Lines: 59
Message-ID: <t4s7pm$72p$1@dont-email.me>
References: <bd33d576-4c93-48b0-a72b-fce6ab948ae6n@googlegroups.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-15"; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Tue, 3 May 2022 21:45:26 -0000 (UTC)
Injection-Info: reader02.eternal-september.org; posting-host="d1291a5e4cafdb94eca76b0201e0d8c0";
logging-data="7257"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX190it6+ZXkJB/WDprZ78mEA"
Cancel-Lock: sha1:qe2ODBdcMohgCa2YV5O9PTK6Tzk=
X-Antivirus-Status: Clean
X-Newsreader: MesNews/1.08.06.00-gb
X-Antivirus: AVG (VPS 220503-14, 5/3/2022), Outbound message
X-ICQ: 1701145376
 by: Ron Weiner - Tue, 3 May 2022 21:45 UTC

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 the tasks you are interested in the Where clause.

Here is some "Air Sql" to create the output you want.

TRANSFORM Min(CompleteDate) AS MinCompleteDate
SELECT TaskName
FROM YourTable
WHERE TaskSelection in("Task1", "Task2",....)
GROUP BY TaskName
PIVOT TaskSelection;

Somewhere in front of this sql you could have a form that allows the
user to Select the Task Selection(s) they want to see, and "Bob's your
uncle".

You also will want to control the Values in Task Selection. That would
require another table TaskSelection of with 2 columns TaskSelectionId
and TaskSelection. Then TaskSelectionID becomes a Fk YourTable that you
perform the Crosstab on.

Or perhaps I have totally misunderstood your question.

Rdub

musicloverlch formulated the question :
> 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 the table would have fields like
> Task Section TaskName CompleteDate
> Census Email Sent 1/1/2022
> Census Census Received 1/5/2022
> Census Financials Received 1/7/2022
>
> The goal is for the user to be able to add however many tasks they want
> without me needing to be involved.
>
> My problem is that I would then need to make a view where they could see all
> the tasks horizontally. The tasks might change so I can't put a fixed list in
> the crosstab query.
>
> I really want to do this because I'm sick of having to add fields every time
> they want to track some new date, but I can't figure out how to overcome the
> crosstab problem.
>
> Thoughts? TIA
>
> Laura

Re: Brainstorming Ideas

<7d884cea-140a-4c0a-bd22-ad8872bc9899n@googlegroups.com>

 copy mid

https://www.novabbs.com/devel/article-flat.php?id=563&group=comp.databases.ms-access#563

 copy link   Newsgroups: comp.databases.ms-access
X-Received: by 2002:a37:695:0:b0:69f:b916:2d8e with SMTP id 143-20020a370695000000b0069fb9162d8emr17940183qkg.680.1651714560829;
Wed, 04 May 2022 18:36:00 -0700 (PDT)
X-Received: by 2002:a05:6870:a901:b0:da:cf13:4023 with SMTP id
eq1-20020a056870a90100b000dacf134023mr1160708oab.90.1651714560489; Wed, 04
May 2022 18:36:00 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ms-access
Date: Wed, 4 May 2022 18:36:00 -0700 (PDT)
In-Reply-To: <t4s7pm$72p$1@dont-email.me>
Injection-Info: google-groups.googlegroups.com; posting-host=2601:2c7:8c00:17f0:c51:7268:5c73:507b;
posting-account=Lr72qQoAAADkUv-gyUq0hiLVTj6vT-m8
NNTP-Posting-Host: 2601:2c7:8c00:17f0:c51:7268:5c73:507b
References: <bd33d576-4c93-48b0-a72b-fce6ab948ae6n@googlegroups.com> <t4s7pm$72p$1@dont-email.me>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <7d884cea-140a-4c0a-bd22-ad8872bc9899n@googlegroups.com>
Subject: Re: Brainstorming Ideas
From: lho...@gmail.com (musicloverlch)
Injection-Date: Thu, 05 May 2022 01:36:00 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Lines: 3
 by: musicloverlch - Thu, 5 May 2022 01:36 UTC

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 were in a crazy order.

Re: Brainstorming Ideas

<t4vauv$sem$1@dont-email.me>

 copy mid

https://www.novabbs.com/devel/article-flat.php?id=564&group=comp.databases.ms-access#564

 copy link   Newsgroups: comp.databases.ms-access
Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: rw...@domain.com (Ron Weiner)
Newsgroups: comp.databases.ms-access
Subject: Re: Brainstorming Ideas
Date: Wed, 04 May 2022 21:57:50 -0400
Organization: WorksRite
Lines: 19
Message-ID: <t4vauv$sem$1@dont-email.me>
References: <bd33d576-4c93-48b0-a72b-fce6ab948ae6n@googlegroups.com> <t4s7pm$72p$1@dont-email.me> <7d884cea-140a-4c0a-bd22-ad8872bc9899n@googlegroups.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-15"; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Thu, 5 May 2022 01:57:52 -0000 (UTC)
Injection-Info: reader02.eternal-september.org; posting-host="4bfcb1877735d20226bf527f1f3a578e";
logging-data="29142"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+hxaECqU5w0EuwyvHLlpdO"
Cancel-Lock: sha1:MAHVgYdM+DbrkMvYROtXfHbhMVQ=
X-Antivirus-Status: Clean
X-Newsreader: MesNews/1.08.06.00-gb
X-Antivirus: AVG (VPS 220504-10, 5/4/2022), Outbound message
X-ICQ: 1701145376
 by: Ron Weiner - Thu, 5 May 2022 01:57 UTC

musicloverlch expressed precisely :
> 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 were in a crazy order.

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

As for the crazy order of the Column headings you can use an IN()
statement at the end of the PIVOT statement to put thinks in whatever
order makes sense for you. Something like:

....
PIVOT TaskSelection IN('ThisTask','ThatTask','AnotherTask');

Rdub

1
server_pubkey.txt

rocksolid light 0.9.7
clearnet tor