Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-02-2004, 07:36 PM   #1
myme
Registered User
 
Join Date: Feb 2003
Location: Roseville, CA
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
myme
What is the easiest wayto do a daily calculation for a field in a table!!

I am having a problem doing a daily calculation for a certain field within table. Here is my scenario: I have a table w/ the folling fields

intSNC curBalIn SumOfcurPayment PBal interest Total
36349 $1,000.00 $166.00 $834 $.34 $992.24

I want to be able to pull the current interest owed and multiply the PBal by .1, then divide by 365 and add the interest to the new interest and then put back the total interest back into the interest field and do this daily. What is the easiest way to do it. I been trying with queries and can't seem make it do what i want it to do. thanks

myme is offline   Reply With Quote
Old 05-02-2004, 11:42 PM   #2
Parker
Registered User
 
Parker's Avatar
 
Join Date: Jan 2004
Location: UK
Posts: 316
Thanks: 0
Thanked 0 Times in 0 Posts
Parker
Please do not make multiple posts.

This is confusing and exceedingly bad manners.

Read the forum FAQ's and use the search facility.
__________________
Today’s nutter maybe tomorrows genius so don't call me a nutter-----just in case
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Parker is offline   Reply With Quote
Old 05-03-2004, 03:36 AM   #3
Oldsoftboss
AWF VIP
 
Oldsoftboss's Avatar
 
Join Date: Oct 2001
Location: in the shed
Posts: 2,504
Thanks: 0
Thanked 56 Times in 48 Posts
Oldsoftboss will become famous soon enough
What is the easiest wayto do a daily calculation for a field in a table!!

With a calulator, I supose !! Ha Ha Ha Ha Ahhhhhhhh

__________________
Apathy is on the increase, but who cares.

Imagine if there were no hypothetical questions

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Oldsoftboss is offline   Reply With Quote
Old 05-03-2004, 01:46 PM   #4
Joe8915
Newly Registered User
 
Joe8915's Avatar
 
Join Date: Sep 2002
Location: Colorado
Posts: 821
Thanks: 66
Thanked 2 Times in 2 Posts
Joe8915 is on a distinguished road
I think your best bet is using the queries. So far there isn't anything I couldn't do, with using a queries. You might have to add a couple fields in the query to make it work. Just my thought

__________________
Men and Women love their country, not because it is great, but because it is their own.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Joe8915 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 08:15 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World