Search results for query: *

Bascially, I think it's just the from statement. The select query is for the first two quieries should only pull from the heat.calllog table. all the others should pull from the join below From Heat.CallLOg inner join Heat.Asgnmnt on HEAT.CallLog.CallID=HEAT.Asgnmnt.CallID Thanks Janet...

Hi lbass, My other issue is basically I have 9 seprate queries I want to be in one CR. I'm like super new at CR so I'm almost clueless on how to do this. I want to have the results of all 9 show up in one CR. asknelson19 was kind enough to place all 9 in one big select case statement which I...

OK new issue. The first two sum/select statments only pull of the heat.calllog table. The rest pull off the join of two tables. So I can't get that part to work correctly. Also, I want to be able to use the between statement for the query for dates, I have 3 date fields though and each...

Yes, That worked!!!!!! Thank you soooooooooooooooooooooooooo MUCH!!!! your a life saver!!!! Thanks Janet [ponytails2]

Thanks, I'm trying it now. There are a few open/closed bracket errors. I'll see if this works. So I should just place this in the same command as I had the last one, right? Thanks Janet [ponytails2]

Hi want to create one crystal report that returns the values for several items. I opened up a new report and the only thing I added was a command. In the command I added the following quieries: select Count (*)As CallsIn from heat.calllog where...

OK I tried that but it didn't work. Not sure if I'm doing it right. I get the error message ... "The remaing text does not appear to be part of the formula." Thanks Janet [ponytails2]

So should I keep my Parameter field called date range? Thanks Janet [ponytails2]

Hi, I'm extremly rusty on Crystal and I need to create a report for our VP ASAP so I'm in a panic and not having any luck. I have a table called Calllog The fields I need in the report are CallLog.ClosedDate and CallLog.RecvdDate. All I need is a count of records with a CallLog.ClosedDate...

Hi, I just have a parent record with a child record attached to it with a primary key. So, the main recored has a column named childID. If I remove the value from the parent record with txtID = "", then the child record will be disacosciated from it. In other words I have a main form with a...

Hi, I ran into this problem a long time ago, however I cannot remmeber the solution [sad] I have a form with mulitpule pages with subforms in each page. For some reason all of a sudden some of the subforms dissappear. If a record doesn't exist or if I go to add a new record the subform...

Great, Thanks this worked. This was a good work around. Thanks Janet [ponytails2]

Hi, I'm just now begining to work with Crystal Reports and I have a crosstab report that works great, but the format is not. I can seem to put my crosstab anywhere execpt for the report header and footer so this throughs of my page numbering. How can I get my crosstab to be in the Details...

Thanks Everyone!!! Ken it worked,it was by number. I used ORDER BY DatePart("m", tblYouth.DOB) Thanks you all are wonderfull!!!! Thanks Janet [ponytails2]

OK,I thought this was working correctly but it's not. In the query below I'm trying to order the tblYouth.DOB date field by month. The format of the field is mddyyyy in the table. The order by ("M" tblYouth.DOB); is the part that's not working correctly. SELECT tblYouth.FirstName...

Thanks everyone for your help. I appreciate that Thanks Janet [ponytails2]

Hi I have a small task I've been scratching my head over and thought it best to start from scratch. I have a table with a date field, data type is date. The problem is I want to sort it by month, however if I sort by asc or desc is does it by year. I created a new table that fills in a date...

Hi TheAceMan1 , I'm doing better now this is working. Thanks for the function. I knew there were several ways to accomplish this. I'll give your code a try also. This should help my learning process. Thanks again everyone:) Thanks Janet [ponytails2]

Hi Zion7 and JoeAtWork, I was able to figure it out. Thanks so much for both of your help. With everything going on in the world its a refreshing feeling to know there are people willing to lend a helping hand and a word of advise or encouragement. Again thank you soooo much!!!!! What I...

Hi Zion7 and JoeAtWork, Thanks for the feed back. My objective is to update all records at the same time. I'm sort of self taught at programming (which means amateur and probably doing things the hard way or wrong). "Your code is nested in the following IF block, which appears to be for just...