Only Display Data Entered Form

[anamque]

Hello,

I have 4 databases that link into one main database. The main database holds
information for the employees monthly bonus.

So I would like to create a form - where the employee can go into at
anytime, type in the dates that they would like to view, and they will be
able to view the information that they entered by those specific dates.

To step it up a notch - I want to calculate they're projected commission for
the current month based on the records they've entered.

to break it down:

I have a "calls" (number of calls answered) database - I need to display the
number of calls taken month to date and in a seperate column and to then
multiply that number by 2 (since they are given 2x credit for each call). I
then have 2 other seperate databases that contain account information. I
would like it to pull those records entered by that specific analyst viewing
the form (not to display all data from all analysts) and then add those
figures up. With those figures adding up - I want to create something that
tells them how far they are from hitting goal. So if they are at 500 accounts
worked for the month - and the goal is 700 - in a seperate field I would want
it to display the difference.

Would this be easier to do in infopath or access?

*****I don't want them to have the ability to revise the records - only to
view the records they've entered

 

[Arvin Meyer MVP]

I don't know about InfoPath, but this can definitely be done in Access. I'm
not sure why you have separate databases other than possibly they are not
connected to the network. It certainly would be much easier on you if you
could put everything in a single table assuming the data is the same.

The functions and properties you need are all built in to Access.