|
Posted by Dan on 11/29/06 09:27
Hi
I've got a quandry - I have a detailed database that handles advert
orders between a design agency and printers / magazines etc.
I want to add up the total spent by the client and put the results to a
field.
I've actually done that using a query table in access - it should be
quite simple as i can bind the 'total amount' to my table - the only
thing it does not currently do is filter the total based on the month
selected.
For example if you look at
http://www.daneverton.com/dg2data/months/2006-12.asp
The data here is filtered by the issue equaling Dec-2006
The actual order total is £13,622 but the column is showing the total
for all entries to date (a years worth = £ 422,048)
I'm sure that there is only a basic tweak required but i'm banging my
head over what to do
The sql is "SELECT * FROM monnodraught, q_monodraught_total WHERE
[Issue / Edition] LIKE ? ORDER BY Publication ASC"
Any help gladly received.
Navigation:
[Reply to this message]
|