"Patrick Finucane" <patrickfinucanetx (AT) gmail (DOT) com> wrote
On Apr 30, 9:00 pm, "Neil" <neil.ginsberg+newsgr... (AT) gmail (DOT) com> wrote:
"Patrick Finucane" <patrickfinucan... (AT) gmail (DOT) com> wrote in message |
news:919dbcde-cad0-4feb-b508-8476e981423b (AT) t16g2000yqt (DOT) googlegroups.com...
On Apr 27, 9:24 pm, "Neil" <neil.ginsberg+newsgr... (AT) gmail (DOT) com> wrote:
In Access I build reports using temporary tables in the front end. But
putting my Access on SharePoint I can't do that. Any tips for how to
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, adding a
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
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
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