Recent content by talibm

Thank you LB. Worked like a charm.I really appreciate you help' talib Stay safe and healthy

The report is group by program value and client PATID number. summaries are for each client and program in the respective group footers. thanks

Thanks guys for you response and I apologize for the lack of details. We have a crystal report that has two table, episode_history and worker_rating1. The episode_history table contains program data and the worker_rating1 table contains the survey data. The database is Cache. The...

We have created a survey data collection form. The Survey type field is single select field. It has values initial, 30 day, 90 day, 6 month, 9 month and Termination. I am trying to select just the data for Surveys that have an initial and termination surveys. We have calculated scoring for each...

Hello LB, Your suggestion worked like a charm. You're the best. Thank you very much!

The {Answer.QuestionUid} = 9993 and {Answer.Answer} = "1" represents the number of years the client has been employed. I need to be able to combine the number of HS-GED or No-HS_GED responses with the corresponding number of years. These are the actual formulas I need to combine and then...

Hi All, I have a Crustal Report (2013 that pulls data from a sql database. I have created several formulas that I need to combine calculate the number of client that have a high school deploma/ged and clients that do not have a high school diploma/ged. {Answer.QuestionUid} = 10039 and...

Hello Skip, The answer.answer field that I am try to convert to datetime is a varchar data type that allows nulls. Any suggestions? thanks

Hi All, I am a novice at sql and would appreciate it if someone can help me with a view that am trying to create us ms sql 2005. I am trying to convert a varchar field to convert it to time field using a datetime. the syntax check validates the view, but when I try to execute the view I get an...

Hi Pete, Thanks for your help. I apologize for my lack of information at the outset. The tables that i am trying to get the data from were created from a web application. Each question has a tag/row and the response to all questions is collected in the answer field which is a memo field. Having...

the section names represent the tab in the web page when the data is input. The Preamble section in the first section where the interview begins and the Motivation section is where the end time is located. The modified formula that i posted works. It give me the correct times, but I cannot get...

I am trying to explain. Maybe not well enough. Anyway thanks for your time. talib

Hi guys, Maybe I need to take a step back and give you more background info. The data that I have is entered via a web application that was created for us by a 3rd party. There are 3 tables that I am using. The interview table, the question table and the answer table. The interview date , start...

Hi guys, The reason for the start time and end time reflect the office hours for this program. 8 am to 5 pm. The building opens at 8 and closes a 5. First let me say that all the times show as am, except 12:00 to 12:59, when I converted the string to a time field. So that time period is omitted...

Hello guys, one last hurdle. My datediff formula, DateDiff ("n", {@end_date_time}, {@start_date_time}), is returning 0.00. What am I missing here? thanks talib