Search results for query: *

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

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

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

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, I'm having a problem with some code (record set) I wrote. I want to check for members of a group to see if they have been absent for 30, 60 and 90 consecutive meetings (not calendar days). Basically a person will have a record in the db for everyday a meeting took place. Their record...

Hi Everyone, I'm having a problem creating an MDE. My database is 11mb in size and in 2002-2003 format. It has 3 modules, 50 tables, 450 queries, 35 forms and 33 reports / subreports. It is not a replica databas. I have went to a form and opened the code and performed a compile project...

Hi, I'm having trouble creating an MDE version of an ACCESS 2000 database. I tried converting it to 2002 with no luck and I also opened up a form in design view, opened the view code mode and debugged / compiled it with no luck. Do I have to do this with every form and is this the right step...

Hi, I have a form with multiple tabs. Each tab page has a sub form within it. Every time I go to add a record the sub forms are missing. This worked at one point. I checked the Sub form Field Linder properties, which link the child and master fields between the form and they seem ok. Any...

You know the saying give a man a fish and he’ll eat for the day, but teach a man how to fish and he’ll eat for a life time. I often see many talented people responding, with relative ease, to questions about queries that I think are very complex. I’ve purchased SQL for Dummies and Access 2000...

Hi, I posted this question in the reports forum,but I think it belongs here. I have a subform that has a command button that is used to open and run a report, only for the specific record shown. The problem is that when I press the command button the report shows behind the form so I can't see...

Hi, I have a subform that has a command button that is used to open and run a report, only for the specific record shown. The problem is that when I press the command button the report shows behind the form so I can't see it. I've tried to make the form/subform invisiable but it doesn't work...