I know I can keep a running total, but I was thinking that this would
be very slow after a while and not very efficient. For example, if it
calculates everything for three years, that's a lot of number
crunching. I know I could narrow it by month or something, but other
than that it'd be intense the larger the db got.
I thought about a table with a starting balance and from there do my
debit and credit, updating the starting balance column each time and
grabbing that value when I need to know the balance. Other than that
I know of nothing but a running total simply adding and subtracting as
needed. Thanks for thoughts. 3 4913
Per jmDesktop:
>I know of nothing but a running total simply adding and subtracting as needed. Thanks for thoughts.
Quicken.
--
PeteCresswell
JET/ACE SQL is very quick at summing. Unless there are many, many
cheques a day, calculations for three years will seem to be
instantaneous.
You say, "I know I can keep a running total"; Where? How? Running
Totals and Counters are not dealt with happily and easily by JET/ACE,
and by Access, only in Reports. Maybe there is something new in Access
2007 I haven't noticed?
On Jun 16, 10:32*pm, jmDesktop <needin4mat...@gmail.comwrote:
I know I can keep a running total, but I was thinking that this would
be very slow after a while and not very efficient. *For example, if it
calculates everything for three years, that's a lot of number
crunching. *I know I could narrow it by month or something, but other
than that it'd be intense the larger the db got.
I thought about a table with a starting balance and from there do my
debit and credit, updating the starting balance column each time and
grabbing that value when I need to know the balance. *Other than that
I know of nothing but a running total simply adding and subtracting as
needed. *Thanks for thoughts.
On Jun 18, 8:24*am, lyle fairfield <lyle.fairfi...@gmail.comwrote:
JET/ACE SQL is very quick at summing. Unless there are many, many
cheques a day, calculations for three years will seem to be
instantaneous.
You say, "I know I can keep a running total"; Where? How? Running
Totals and Counters are not dealt with happily and easily by JET/ACE,
and by Access, only in Reports. Maybe there is something new in Access
2007 I haven't noticed?
On Jun 16, 10:32*pm, jmDesktop <needin4mat...@gmail.comwrote:
I know I can keep a running total, but I was thinking that this would
be very slow after a while and not very efficient. *For example, if it
calculates everything for three years, that's a lot of number
crunching. *I know I could narrow it by month or something, but other
than that it'd be intense the larger the db got.
I thought about a table with a starting balance and from there do my
debit and credit, updating the starting balance column each time and
grabbing that value when I need to know the balance. *Other than that
I know of nothing but a running total simply adding and subtracting as
needed. *Thanks for thoughts.- Hide quoted text -
- Show quoted text -
I only meant I know it's possible. I've seen threads where it was
mentioned. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: G Kannan |
last post by:
Hey all!
I have written a perl script to retrieve information from a HTML Form
and insert the data into an Oracle database table. I am gettting the
the following error message:
"Use of...
|
by: Alex |
last post by:
I apoligise in advance if this is an os or platform based question, I
don't know.
I was wondering how register integers (and other types of register
variables) are managed by c++. For example,...
|
by: aruna |
last post by:
What is the disadvantage of using register
storage class specifier?
|
by: Jackie |
last post by:
Hi everyone,
Does anyone know when "register" declarations should be used and when
"register" must not be used? If possible please give examples for both
cases.
Thanks
|
by: orium69 |
last post by:
hi everyone, i'm wondering if there is a way to have sure that a
variable is allocated in the cache, after its declaration with
"register"? Tks!
|
by: Snis Pilbor |
last post by:
With the "as if" rule in play, doesn't that effectively render the
"register" keyword completely useless?
Example: I make a silly compiler which creates code that goes out of
its way to take a...
|
by: prouleau001 |
last post by:
Hi all!
Since that the decorator syntax is upon us, I think it would be good if
atexit.register() was returning the function passed as argument. This
simple change to the library would solve a...
|
by: Vashna |
last post by:
Hi Group,
I have a doubt about register variables.
I know that if we have a variable used very frequently in a function,
then provided we never apply the & function to it, we can define it as...
|
by: ringer |
last post by:
Hi,
I wrote myself an Access db several years ago to do some things for my checkbook and budgeting and I've really enjoyed it ever since. Lately I've been thinking about writing it as a stand alone...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |