Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / December 2006

Tip: Looking for answers? Try searching our database.

Calculate results of query in repeating table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Carlos F. - 22 Dec 2006 18:20 GMT
I got a very small application using Infopath to submit and query data
of an Access Database.  The database is quite flat and not complicated
since it stores different students evaluations.
For example:
EvaluationID
StudentID
Score Section1
Score Section2
Score Section3 etc.

For all intented purposes is working fine, but I hit a snag with the
query I wanted to do. I wanted a query that would show me all the
evaluations of a particular evaluator or student, so I digged through
Infopath and managed the result I wanted with a repeating table.

Everything was perfect until I decided that I wanted to do some
calculations per evaluation for review purposes. The results of the
calculations don't have to be stored anywhere, which I figured would
help me out.  Unfortunately it hasn't.
Everytime I tried to do this, the result of the calculation of the
first query repeats itself out across the entire result list.  Of
course, if my query only turns back one result, it works perfectly.

As you can gather, I have zero knowledge of code, which is why I am
hoping someone out there can give me a no-code answer.

Thanks,
Carlos F.

PS: I have tried current() in all its permutations without much success.
Carlos F. - 28 Dec 2006 15:46 GMT
Found solution!

My main problem was using a field for the data. Using an Expression Box
seemed to make current() work much better and I didnt' have problems as
I had with the field data. What I found disconcerting was that I used
current()/@ScoreSection1 on both occassions and it only worked ok on
the Expression Box! When I used it on a text box it didn't seem to work
properly.

Anyways.. There's my solution.

> I got a very small application using Infopath to submit and query data
> of an Access Database.  The database is quite flat and not complicated
[quoted text clipped - 26 lines]
>
> PS: I have tried current() in all its permutations without much success.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.