Search results for query: *

Hi guys I am using CRv8.5 and pulling data from MS Access97. I am unable to write the header in csv file. My csv file output is similar to the one in the following post http://tek-tips.com/viewthread.cfm?qid=1451173 I have my header in the report header section. How do I solve this problem...

Hi Can anybody explain what is the purpose of creating a duplex report and what is so different about it? I read the thread number 703-1397286, which was pretty helpful. But I still need more clarification. I have not created a duplex report before. Thanks.

I am using CRW8.5 and Acess97. I have to create a CSV file with 40 columns. I am writing the header info in the Text Box and it is placed in the Page Header section of the report. When I open the file in notepad. I see the header information being repeated. I am not sure what I am doing here...

I am using CRW8.5 and Access 97 The database table looks like as follows: Hours bcode 25.01 VAC blank blank 36.6 PTO I wan the output like as follows: Hours bcode 25.01 VAC 0 0 36.6 PTO Hours data type is number. Following is my formula: WhilePrintingRecords; numberVar nOutput :=...

Using Access 97. Need to select data based on the following condition. Select * From tempTable Where (tempTable.date >= '01/01/2007') or (tempTable.date is null) data type of tempTable.date is Text. When I use the following code Select * From tempTable Where tempTable.date >= '01/01/2007' It...

I am using CRW 8.5 and ACCESS97 I have to select data based on the following condition. Get all the records where date field is null or date >= 01/01/2007 I am coding as follows If is null ({table.datefiel}) OR {table.dateield} >= "01/01/207" Is it possible to do something like this?

I want to adjust the formatting of the telephone number. as "123-456-7890" right now it is displaying as 1234567890. I am using Access97. my database field name is "Best time to call" data type text. How do I change the formatting? Do I need to write a VB code or go into expression builder...

I am using CRW8.5 and access97 Can you write DROP, CREATE, UPDATE, SELECT INTO statements from SQL Designer tool. I am getting the following error ODBC Error: [Microsoft][ODBC Microsoft Access Driver]Cannot modify the design of table 'eaccr'. It is in a read-only database. I have full access...

I am using CRW8.5SP3 and Access97. I am trying to export the report in excel8.0 extended format. When I open the file there is a blank column added to the front of the report. Which has to be deleted every time I open the excel file. Data wise the report is ok, Report is also fine in the CRW...

I am working in access97 need help in writing a query Table1 has two columns with ID and NAME. Table2 has has two columns, ID and CHECKDATE. In Table2, there are multiple checkdates associated per ID I like to run a query which will give me the highest checkdate on each employee in Table2...

I am using CRW8.5 and Access97. Is there a way to run sql statements from CRW8.5? I have to run about 10 or more sql statements and output the results in table. Then write my report off that table. Thank you.

I am using CRW 8.5 Access97. When I browse field data box of the log.id in CRW8.5 I don't see the full list of values. But I do see the values in the report. for example Browse field data box for log.id will contain 115,144,156....but 823 and 873 will not show up in the browse list and they...

I am using CR8.5 SP3 and Access 97. I am creating a report that has database field separated by comma it has 23 columns. I run this report from a different application that uses CR8.5 engine. I export that report into text format and works fine at my PC. But I don't get the same results on a...

I am using CRW8.5 and ACCESS97 I have two fields type Date/Time. Is my comparing criteria correct? The following formula is not printing the Einfo.hiredate field. Einfo.rehiredate is also blank whileprintingrecords; if{EInfo.hireDate} <= {EInfo.rehireDate} then {EInfo.rehireDate} else...

using CRW8.5 and access97 I like to know if there is a function that will remove hyphen(-) from social security numbers. Thanks.

I am using CRW8.5 and Access97. I have to calculate the number of active and terminated employees in different dpeartments. I am able to group the report by department, which is simple. I am not able to initialize the variables before the next department and as a result the variable increments...

I am using CRW8.5 with Access 97 database. Reprot is giving me desirted output in the CRW8.5. However, when I export to Excel using the Excel8.0 extended format the columns are not showing in the correct order. After column U there is no columns. I have installed SP3 on CRW8.5 but even then it...

I am using CRW8.5 with Access 97 database. Reprot is giving me desirted output in the CRW8.5. However, when I export to Excel using the Excel8.0 extended format the columns are not showing in the correct order. I also tried exporting to PDF and it is working there. But I need to use excel...

I am unable to view all the columns in the CR8.5. I have installed the driver for HP Design Jet 3500CP PS3, that fixed the problem for one report, but when I created the reprot I am still having the same problem. Thanks

I am using CRW 8.5 and MS Access97. Using Round(x) function in formula to remove decimals in the numbers. The field size in MS Acess is Double and decimal places is set to Auto. Round (x) in CRW rounds the number but it is not removing the decimals. for example. When you preview hte results in...