heres a thought!!
i didnt know poo poo about crosstab qrys but have managed to create one that gives a glimmer of hope.
TRANSFORM Count(qryClients.[ID#]) AS [CountOfID#]
SELECT qryClients.EmploymentStart, Count(qryClients.[ID#]) AS [Total Of ID#]
FROM qryClients, qryStatsClientCount
GROUP BY...
Duane, ive tried to type them into this forum but when I preview the message it looks very disjointed and mixed up, ive tried to do a screen capture and then paste that, didn’t work. I so much appreciate the time you have given me, it’s much more than one can reasonably expect. Im not sure what...
i tried to put together a tbl of records, but when i previewed it it came out all disjointed. i tried to do a screen capture and then crop it to paste it in here and failed...short of that here is something that may or may not help.
tblClients
fldID# - Primary Key
ReferalDate - Date/Time...
oops, i just realized i left something out. im still working on getting the little chart thing to display this data over a period of months as they go by, adding bars as time passes. as it is now i get a 'snapshot' view of the stats.
regards,
milk
got it working. ive been tinkering with it some more and here is what ive gotten to work.
i created three qrys, one that counts the total client records. another that counts the records that meet a certain criteria. in a third qry i have combined these two counts and built an expression that...
yes one bar but as the months go by im hoping to have one bar for each month. thusfar ive not been able to compute the percentage and have it displayed in the chart.
regards,
milk
Thanks for your quick reply.
i hope this helps.
in the end im looking for 3 bar charts
-percentage of clients that obtained employment in last 60 days
-percentage of clients that show an earning progression
-percentage of clients cases closed with earnings
thusfar i have been able to...
to expand on my earlier posting;
my source date looks something like this...
qryClients
(the Fields)
ClientID
ReferalDate (date refered to services)
EarningsStart (starting salary)
EarningsEnd (salary at end of case)
CaseClosedDate (date case closed)
good day all,
im trying to create a report that will display some stats. to begin with i have a qry that contains client information for a good many clients. here is what ive got so far. here is what im aiming for;
percentage of clients that obtain employment in last 60 days.
percentage of...
musta been something i did to the form at an earlier time to mess it up.
i just fixed it. what i did was create a new form and copy all the controls from the old 'frmclientinformation' into the new one, now the selection from the list box works wonderfully!!!!!!
thanks so much for your...
the allow filter is set to yes.
the form opens to a new record. id rather it opened to the record im dblclicking on in the listbox.
cant thank you enough. hats off to ya.
milk
thanks...that took care of the error. the second form still opens to a blank form though.
the field [caseNumber] is numeric.
the record source for the second form is the same qry that the listbox pulls data from. should i have placed anyhting in the filter property, or some other property...
so sorry for not 'getting it'. ill try not to bother you all with this much more. the second form opens wonderfully but i get an error...
run-time error 3075
syntax error(missing operator) in query expression 'CaseNumber=60000112
'that case number is the number something we generate ourselves...
Thank you both for your quck reply. absolutly wonderful. the post from wemeier worked to open the form, thank you as well Jeff, like you said there seemed to have been a comma issue. still cant thank you enough.
now that i have to form opening nicely, ill have to beg one more thing from you...
hello all, i need a bit o'help with this. i have a form that contains three listboxes. each list box shows a listing of clients that are working with a particular job developer. the list box info is just the name of the client and the date refered to us. i have a second form that contains a...
Here is a thought.....
...create a cmd button that does what you want
...place it on top of the picture area you want to be a hotspot and change the buttons transperancy property to yes
ive done this a couple of times and it works wonderfully. i use the hidden buttons as hotspots to launch...
Hello everyone, i need a bit of help. i have a form (dont we all) that ive built this rather lengthly iif statement expression into the after update property of a textbox control. works great, but.....id like to play a bit with the idea of limiting the number of controls on my form. hence the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.