Search results for query: *

This maybe easy for some but I am fumbling with this. I have a table where a one time sale is broken into several categories. The itemization code identifies the part that is Tax, Doc Fees, Prep Fee, etc. Each category becomes it's own record. See below. AAD_ID ACD_ID SEQ ITEMIZATION_CODE...

This is a very basic question. I am using SQL Server 2000 and I want to add a colmn to a table that will insert the date or date/time when the data is loaded into the table. I appreciate the help. Noslo

Hello All, This is probably pretty easy but I am stuck because I haven't used Crystal Reports in a while. I am using CR8 I am trying to create a field from a phone number field displaying the 4, 5 and 6th digit in a phone number. Ex:[PhoneNumber] = 3135551212 New Field = 555 How can I...

Hello All, Please bear with my basic request. I am new to SQL Server. I am trying to create a column from a phone number column. I am trying to isolate the 4, 5 and 6th digit in a phone number. Ex:[PhoneNumber] = 3135551212 New Column = 555 What code would I use? Thanks for your...

Thanks for the posting, I am new to Web Design. I will give it a try. I appreciate the help. Helen

Hello All, I am fairly new to FrontPage 2002. How do you set up FrontPage to allow someone who has completed an order form, noticed an error on the confirmation page to go back and edit the original data? Currently, when the user hits "edit data" from the confirmation page, it takes...

Hello Helpful Ones, I am using CR 8 and am a basic beginner. Here is my problem. I have a time field in my SQL database. When I create a report using this field, it changes it to a date. I looked at report options and the FAQs without result. An example is 9:20:15 am in SQL is displaying...

Thanks for the help, redlam. It worked. Once again, I appreciate the members of this board who are willing to help people like me who are new to SQL server. Tip: Never fry bacon without a shirt on.

I am fairly new to SQL Server 2000. The answer to my question may be obvious but it currently evades me. I am importing data into SQL that has a field that measures the length of a phone call as hh:mm:ss When I import the data, SQL wants to display the data as a point in time (Date/time)...

Jim, Thank you so much!!! I appreciate the help. It worked wonderfully. Helen Tip: Never fry bacon without a shirt on.

Hello All, I am using CR 8. I am trying to convert a number to a length of time, hh:mm:ss. The field I am trying to convert measures the length of a phone call. I am having difficulty with the formula to use. Each formula I have looked at wants to convert the number to an actual time...

Thanks for your response BPerry. I appreciate your helpfulness. I'll give it a try. Helen Tip: Never fry bacon without a shirt on.

Hello Wise Ones, How do I code a new column in SQL 2000 which selects all the numbers to the left of a decimal point in another column? The numbers vary from 1.0 to 19999.99 Thanks

Hello, I am building a website with an order form for new customers. I have established the SQL database connection, selected the table, linked the fields on the form to the table. I have entered a few temporary records to test and the table is empty. What else can I check to remedy the...

Hello, I am building a website with an order form for new customers. I have established the SQL database connection, selected the table, linked the fields on the form to the table. I have entered a few temporary records to test and the table is empty. What else can I check to remedy the...

Thanks for the help and the quick response. I'll give it a shot.

I am new to SQL server 2000. I have the Customer_Id column in several tables inthe database. How do I get this data to replicate/cascade to the other tables containing this column? Any help is appreciated.

Please help, I may be over-complicating the issue, but I need to create a quick static page that allows agents out in the field to sign up new clients. How is this different from setting up a basic order page? The agents will be adding to the customer database table, not merely accessing data...

Hello, I am using CR8. I need to be able to identify the immediate Monday after a date. I have searched the Archives, FAQs & Crystal Care Tech Support. I am trying to understand how I can use the DayofWeek() function. Is this the best approach? How would I code to show the first Monday...

Hello, The following code is working except when I try to display the time. I get an error message at the Totext portion that states, The matching " for this string is missing immediately after the second plus sign. I have been working with CR8 for only a month. Can someone...