On May 1, 11:09*am, "Neil" <neil.ginsberg+newsgr...@gmail.com> wrote:
> "Patrick Finucane" <patrickfinucan...@gmail.com> wrote in message
>
> news:78b2833e-4898-4052-baa7-e78a16164125@v1g2000yqm.googlegroups.com...
> On Apr 30, 9:00 pm, "Neil" <neil.ginsberg+newsgr...@gmail.com> wrote:
>
>
>
>
>
> > "Patrick Finucane" <patrickfinucan...@gmail.com> wrote in message
>
> >news:919dbcde-cad0-4feb-b508-8476e981423b@t16g2000yqt.googlegroups.com....
> > On Apr 27, 9:24 pm, "Neil" <neil.ginsberg+newsgr...@gmail.com> wrote:
>
> > > In Access I build reports using temporary tables in the front end. But
> > > when
> > > putting my Access on SharePoint I can't do that. Any tips for how to
> > > compile
> > > report data using SharePoint? Thanks!
>
> > Are your temp tables finite in count and are the field names the same
> > for a specific report? If so, can you create a blank "holding" table
> > that mimics each temp table and link all the temp tables together via
> > a Tempvars!ID value?
>
> > ===========================
>
> > Yes, I could do that. I was thinking of doing something along those lines.
> > Was thinking, though, of using a table with an autonumber field, addinga
> > record to it, and then using the ID value to link the tables. Is that
> > basically what you're saying, but to assign the ID value to tempvar and
> > use
> > it that way?
>
> > Also, at what point would I clear the temp data? With my temp tables I'm
> > just clearing the temp data before the report is run. But with multiple
> > users using the same table, obviously I wouldn't be able to delete the
> > entire table. So when would I delete the data associate with the
> > tempvars!ID
> > value?
>
> > Thanks!
>
> Yes. *I was thinking initialize a Tempvars!Vars variable is set for a
> current "ID" to symbolize the records processed. *Then when you
> complete run delete queries that delete the data for that set just
> processed. *I don't have experience with Sharepoint yet. *I understand
> your limitations tho. *It's clunky but should work.
>
> ==================================
>
> Problem is that the report (actually a form) will be based on the temp data.
> So if I delete it after the form is opened, won't I run into problems?
>
> I suppose I could put the date into the table that gives me the autonumber
> ID for each report, and then, when the form is opened, delete all temp data
> from previous days. Thus, the cleanup would occur for past days, but not the
> current day.- Hide quoted text -
>
> - Show quoted text -

That works for me. But then, I don't have your problem . Good
luck.