James
|
| Posted: 08/20/2002, 7:20 AM |
|
Is this possible to create without using custom code from an access database?
If it is, using it in one of the tutorials would be very useful to neophytes,
such as me.
Any help would be appreciated even if it does require custom code.
Name Date AMount
**** **** 1.00
**** **** 2.20
**** **** 3.50
Total 6.70
|
|
|
 |
Ad
|
| Posted: 08/20/2002, 9:41 AM |
|
Use a union query in the sql tab:
Slect name,date,sum(amount) as Amount
from mytable Group by name,date
union select (' ') As name, (' ') as date, sum(amount) as Amount
from mytable
|
|
|
|
James
|
| Posted: 08/20/2002, 5:42 PM |
|
Ok, I couldnt find anywhere to enter it in Codechange, so I presumed I had to do it Access, other than changing Slect to SELECT kept on giving me error messages about select statement then FROM statement.
btw i did try to insert it into Codechage as an add code to before show got same sort of error messages..of course iset up the table mytable and layout as per above
|
|
|
|
Nicole
|
| Posted: 08/21/2002, 4:52 AM |
|
James,
create two Grid forms and locate them one under another.
The first form would display the list of records.
Use custom sql query as datasource for the second listbox:
select sum(Amount) from table_name
and add only one field to the second grid that displays the sum.
|
|
|
|
James
|
| Posted: 08/21/2002, 4:24 PM |
|
Works great and such an elegant and precise answer.
Do you work for Codecharge?
btw i see you responded at 4.00 in the morning...maybe you should drink less coffee:)
I am working on a site which I could certainly use some help with, I can pay $25 an hr (yeah i know its way below what your worth). the good thing is I can be available when you choose) if your open my email is (ajamesroberts@hotmail.com) Its my junkmail email so please put in Nicole and Codecharge in title if interested..Anyway thanx again:)
|
|
|
|
|
