Re: Update numbers in database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

im sorry for my bad explanation, but i try as good i can.
maybe this is better:

I have a database with many posts.
I use a form to make all the inputs.
I have queries to make information on a report linked
to the database, using a form with combobox for selecting what info to show.
in the database the user will make inputs looking like 5,3 or 7,3. theese
numbers
represents experience time before registration in the database. (months or
years)
Also i have two posts in the database showing dates, one representing the
date of first time registration and one representing date this time onboard.

how can i update the inputs looking like 5,3 or 7,3 using the input numbers
and date? example,.. when a year have ellaps after the first time
registration the 5,3 number should show 6,3 and the 7,3 number should show
8,3. or after 6 months 5,3 should be 5,8 etc.

post in database (named experience):
years in rank : 5,3 (this number is typed in, and then i hoped it will be
updated when time ellaps)
years on tanker : 7,3 (this number is typed in, and then i hoped it will be
updated when time ellaps)
Months onboard this tour of duty : 2,1 (this number i hoped to show
automatic calculated from access using the date this time onboard)
date first time onboard : an date(11.10.08) user input
date this time onboard : an date(11.11.08) user input

(theese two dates is only for making the update, and is not showing in the
report.
The dates is now only in the database, but i can move them if you have a
better sugestion.)

The number format is a requirement, how its going to show on the report.

(the queries are showing info from database from a name selected from the
combobox. Some info is as described and other is plain text or checkbox. This
information shows on the report.)

So its all about having the input "numbers" for years in rank, years on
tanker,
and months onboard to be updated by access after the first time registration.
The date for this time onboard need to be updated by user every time the
person comes onboard.

brgds
inge
"John W. Vinson" wrote:

On Sat, 29 Nov 2008 18:27:01 -0800, inge <inge@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

Hi,.

I think it is a ordenary database with several (many) posts.
The point with the database is to make several reports, and we can make some
inputs only once. Some posts is experience and the input will be in years or
months like this : 5,3. It will be the same for years or months ofcourse
depending on the experience. I have made this in excel data*** and i only
used the ((TODAY() - (an input date)/30) + the input number) also /12 if
years.
and 30 days a month etc... but i dont know how to do this in access.
working ok there.

Take a look at

http://www.accessmvp.com/djsteele/Diff2Dates.html

It's a VBA function which can take two date fields and display the time
elapsed in various formats, including years/months.

The input experience is the time they have when making the input in to the
database. just a number, something like 6.3 or 10,9. Its going to be in years
or months but looking like 6,3 or 10,9 etc.

I'm sorry, I still don't understand. Are you CALCULATING the number of years
and months of experience based on dates in your table and today's date? Or are
you typing it in? If you're typing it in I'd use two fields...

What i need is how to make the report show with updated numbers or the
database to update the figure from the input figure, and change my queries.

Again: What do you mean by "updated numbers"? Do you want Access to calculate
it, or to display newly manually entered values, or what?

I just managed to make the report show the figures from the database.
but cant see how to autoupdate this numbers.

maybe i need another database for the update?

Access can do what you want... I haven't quite figured out what you DO want so
I am stumbling in attempting to tell you how!
--

John W. Vinson [MVP]

.

Quantcast