Recent content by LOSERMANN

would it be possible if i could email a copy of the dbase to you? regards, Milk

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...

unfortunately i cant share the records. i do have fields for ReferalDate and CaseCLosedDate, though i havent done a qry to compare them. regards, milk

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...

im finished. thanks again for taking the time to look into this for me. regards, milk

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...