By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,401 Members | 928 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,401 IT Pros & Developers. It's quick & easy.

Get data in a particular field from a table in MS Access to use in a function

P: 2
Hi

From a table, I would like to get data from 2 fields, Name and Joining date. For each person I need to calculate how many stages he has passed through. I will write a function which calculates the number of days from joining date and tells me wat all stages he has passed through. It has to be done for all the persons in the table.

The problem is I donot know how to get the Name and the corresponding joining date of the persons from the table.

Pls help.

Thanks

Ramya
Aug 21 '08 #1
Share this Question
Share on Google+
2 Replies


100+
P: 167
Hi Ramya,
The problem is I donot know how to get the Name and the corresponding joining date of the persons from the table.
1. Did you meant how to use these fields in your function?
2. Can you give us a code of your function so we can have a look and help you?

Maybe it would be easier to calculate it in a query...

We really need more info here.
Try to give us some more details on what would be the principle of calculating it.
Aug 21 '08 #2

missinglinq
Expert 2.5K+
P: 3,532
As hjozinovic has indicated, your post is no where near complete! Are you trying to calculate this data for certain persons in your database, and if so, how are you deciding which ones? Or are you trying to do these calculations for all persons in your database?

After we know this we can start to help you. Also helpful to know would be

Name of your table
Name of fields holding person's name and join date

Post answers to these things back and we can start to help you.

Welcome to Bytes!

Linq ;0)>
Aug 21 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.