Search results for query: *

I have the following string field (that is a user defined field) and is inputted to the program as 06/23/97 I need to convert this string field to a date field in CR 8.5 this is the format in the db +000019970623000000 any help on how the formula should be, as I keep getting an...

sorry, that worked and I forgot to add more syntax but I've got it now....help is greatly appreciated. Paul

When my OTPay field indicates a value < or > than 0, and when but when there is actually an OT value, $550.00 I would like to show the PayName field to display OT....instead of regular... the formula goes something like this: if {tblEmpeHours.OTPay} is <> 0 then {tblEmpeHours.PayName} = "OT"...

Let me rephrase the question, both responses dont even come close to the unknown answer. My questions does not indicate I am working with 2006 or 2007 versions of access. Within access, I have a table named 2006 emp med file, and a form we enter data into that populates the 2006 emp med file...

I have a 2006 access database that I have "saved as" a new 2007 database. I have stripped out certain data in the 2007 database, and I want to use the existing "form" and have this form populate the 2007 database. Is this even possible, or do I have to create a new form or completely new...

Thanks to those how helped.....much appreciated.

How do I convert the string to a phone format. Example is ..... 8145551212 to (814) 555-1212 Thanks in Advance...Using crystal 8.5 SQL DB

Update: After further evaluation, I have gone to the accounting application and run an order audit list. The audit list didn't show the problem, the transactions, (before,after changes) did not indicate an item change within the specified period. So this means the accounting application is...

Here is perhaps a better example of what is happening and how the "printing" looks today. Yesterdays Printing 12 apples 2 bags 3 10 apples 1 bags 2 7 apples 5 bags 9 Todays Printing 10 apples 1 bags 2 7 apples 5 bags 9 12...

I am not changing the sort order of the items within a particular customer group. The names in the group are sorted alphabetically, and I know I can change the group sorting , but the line items in the group are changing day to day when there are no changes in the items themselves, and I...

Does anyone know why when I print a report (open order report for example) that on one day it prints items on the report: item a, then item b, then item c, and then the very next day when I print the same report again with "no" changes to any items on the report, it prints item b first, then...

Need to take this one step further I guess, should have explained this a bit further the first time....How would this formula look when the subtotals occur within a group that is within another group........ex. group level is CDN or Canadian and then within another group called WIC? Within the...

I am wanting to do a percentage on sums in a group. I have multiple groups, that have sums (subtotals) within those groups. Right now I only have percentages at the end of my report. Example: Sum ({ARCUSFIL_SQL.amt_age_prd_1}) % Sum ({ARCUSFIL_SQL.balance}) How do I tell Crystal 8.5 I want...