Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Tue Jan 24 08:07:16 CST 2006
Gustav: I'm trying to create a column for the x axis of a graph, so it's for a report. I think I may do what I usually do which is to whip up some code to create a temp table rather than trying to make a query do tricks. I did use the Qcntr thing and it worked. Now I've got to start fiddling with the chart thingy to see if I can get it to behave. This is for a Preventive Maintenance application that I am developing in partnership with a guy in Bangalore. There's not a very big market for the application but it's fun trying to do a joint venture at that distance with someone you've never met. I actually don't think that the graph will be all that useful but it's part of his design so I'm going to do it. He knows the user's needs. Rocky Gustav Brock wrote: > Hi Rocky > > It won't work for a select query you display and browse. > Don't know it that is your case. > > How many records do you have? > Did you try out "my" SQL only trick? Not invented by me and not very fast but fast enough for small recordset and very reliable. And no reset code needed. > > /gustav > > > >>>> bchacc at san.rr.com 24-01-2006 02:14 >>> >>>> > Aha! Thank you. I thought there was something one could do in the > query like the running sum trick but a function with a global should do > nicely. > > Thanks again > > Rocky > > > Charlotte Foust wrote: > >> Take a look at http://support.microsoft.com/?id=94397 "Adding Dynamic >> Counter to Query Count Records" >> >> Charlotte >> > > > -- Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com