Search results for query: *

I have a batch file that contains the following command line: copy c:\data\data.mdb c:\backup\backup.mdb When the batch file runs it asks if it is looking for a file or a folder. The prevents me from running the batch file unattended. Is there a swith that tells the copy command that I am...

I need to create and use a variable in a batch file to rename a file. I don't know what command to use to set the variable.

As part of our back policy I need to copy or rename a file to a name that includes todays date. i.e. I have a file backup.txt that i want to change to 5/6/05backup.txt. I though of using a batch file but I can't find the right commands.

I have a combo box that lists all of the available options to enter in this field. While doing data entry it takes extra time to move my hand from the keyboard to the mouse to click on the drop down arrow. Can I program the box to open with a keystrock like the down arrow instead of the mouse...

Hello All, Is there a way to sum the max of a number example database 15.5 13.5 12.2 report 15.5 13.5 (both max) what I need 15.5 13.5 -------- 29.0

Hello all, How do I run more than one query within a query?

Hello all, I need to force a number to round and then display the integer. right now the number looks like this: Ident Hours 1 40 2 40.25 3 40.15 4 40.56 I need the number to look like this Ident Hours 1 40 2 40 3 40 4...

I have this report that is working very well. The only problem is why I export to a text file it adds an extra character to the begging of some lines. It looks random to me. I will be grateful for any help! Thanks, Tom

Is there a way to display a date (friday) if the date falls on a weekend (Saturday)? I have a dateTime field. If the date falles on a saturday i need the report to display the friday prior. here is the formula I created that does not work: stringvar checkdate := if {SCalendar.checkDate} =...

Hello All, I want to convert data inside of a string. so, I have a formula that converts the data to text and I cant get rid of the decimel. I have a number field that looks like this: .00010 .00297 .00497 I want to data to be in a string and look like this: 00010 00297 00497 Here is my...

Hello All, I created an ODBC connection from crystal to a .csv file on my desktop. I then created a sub report that containes the majorty of the contencs for my report. I created a sub report so that I could link the ODBC to the access97 data base I'm trying to report on. The probjem is that...

Is there a way to link two tables in the same database on a calculation? I have on table that looks like this: FirstName LastName Smith John ... ... The other Table that looks like this: Desc pay-Smith, John Pay-..., ... is there a way to link these two tables?

there is a space generated on each record of my report. does any one know why this is happing?

Is there a way to write a report on a length specific text file? I have a file that looks like this: 907HXRXH,KENNY DUXNE E1 00004.1004 914XXDXNXLD,XXRXXRXE E1 00015.4704 I want to some how tell crystal what the different...

how do i get a bigger printer area? I'm working on an export and I need much more room

I need a simple trim statement that will allow me to use the field starting on the 4th character. I.e.. field 1234567890 Intended Output: 567890

I'm working with a Database that grows as queries are ran. Is there a way to automatically compact and repair the database on a nightly bases?

why am i getting this message? update tempaccrreport inner join caccrchart on tempaccrreport.bcode = caccrchart.bcode set tempaccrreport.accrRate = (select max(caccrchart.accrualRate) from caccrchart) where tempaccrreport.mos > (select max(caccrchart.minimumService) from caccrchart)

Im trying to create a table that will give me the max in a range. if the range is greater then the max I want it to use the highest number Here is my code: The Buld is where im using Or SELECT A.accrualRate, (SELECT Min(B.MinimumService) FROM caccrchart B WHERE B.bcode = A.bcode AND...

I need to know how long an employee has worked at a company. I know the hire date. what is the right formula to produce only the number of months? I was thinking: select (now - hiredate) as MonthsOfService