Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: metalteck
  • Order by date
  1. metalteck

    Sum Question

    Thank you, this was a big help.
  2. metalteck

    Sum Question

    I currently have a report that shows account activity. In this report, the primary fields are being pulled from one table. There is one field called lpchgs, and this is the total charge for an account. Ex. Account Total Charges 444444 $152.00 I created a report to show an accounts...
  3. metalteck

    Time Format Question

    Thank you...your a big help as usual
  4. metalteck

    Time Format Question

    I'm sorry, you are right. Those were typo's. One last question, if the field only has one digit, how would I get it represent in time field, in addition to the formula you gave me? Ex. Actually 6 12:06 am 12 12:10 am 45 12:45 am Thank you
  5. metalteck

    Time Format Question

    I am currently using Crystal 10 and added a field that represents time. Only problem is that its formatted as a number field instead of a time field. How can I convert this over. Now Want to have Ex. 608 6:38:00 AM 1334 1:34:00 PM 1218 2:34:00 PM 2241 10:41:00 PM Thank you
  6. metalteck

    Import Excel Spreadsheet Data

    Hello? Did you need any more information?
  7. metalteck

    Import Excel Spreadsheet Data

    Currently, when I run the Crystal Report to get all of the shipping information it based on the badplpp table. This table contains all of the fields such as account#, name, address, city, state, zip, phone#, and email address. I want the data in the spreadsheet to pull information from the...
  8. metalteck

    Import Excel Spreadsheet Data

    Currently, when I run the Crystal Report, it generates, account#, address, name, city, state, zip, phone#, email address. ex: 77789 Mac Joe Miami Fl 33023 3051234568 joe@joe.com the spreadsheet currently has just a list of accounts and consumer demographic information. EX: Acct# Age...
  9. metalteck

    Import Excel Spreadsheet Data

    I currently have a crystal report that returns account numbers and shipping information I need. I also have a spreadsheet that contains a list of account numbers. I need to take all of the account #s in the spreadsheet and put it into the crystal report, so that I can get all of the necessary...
  10. metalteck

    Formula Question

    The Begin Date returns as a number and returns a result of: 1/14/6 The End Date returns as a date and a result as of:1/14/2006. To make it even more specific, the majority of the calculations will be between the days and possibly the months. Can you show me how to convert this, thank you.
  11. metalteck

    Formula Question

    I currently have a database that calculates the Beg and End Date for the time it took an order to be ordered. I'm using Crystal 8.5. I'm trying to find out how long it took for the order to be taken, but am having a hard time doing it. Can someone please help me. Thank you The formula for the...
  12. metalteck

    Duplicate Help

    I'm currently have a report that lists all patients from 2 different units, units #7 and #11. The patients can have appointments in one of these units or in both. Right now when I generate the report, I get all patients, whether they only have one appointment or 2. I want to be able to only get...
  13. metalteck

    Question?

    I am currently using crystal 8.5. I have no problem with the data that the field gives me. Ex. QTY 5 5 6 7 7 7 What I'm trying to figure out is how I can eliminate the values that only appear once. I was trying to create an if statment, but don't know how to word it...
  14. metalteck

    Time Division Question

    I currently have a spreadsheet that is supposed to do some projected time calculations. In cell a1 I have the number of calls, 8. In b1, the average length of a call, 0:3:25. I multiply both of these cells and get the answer in c1,0:27:20. I have formatted all the time fields to be in the...
  15. metalteck

    If Statement

    Thank you for all your help. This works perfectly. And in the future I will try to be a little more clear and specific. Thank you again.
  16. metalteck

    If Statement

    I see the problem that you were saying. In the formula: ADM = Date ({BADPLPP.LPADT3},{BADPLPP.LPADT1} ,{BADPLPP.LPADT2} ) the year field, LPADT3 is only 1 character long. So when I'm trying to do the difference, you are correct, it is off by 2000 years. Here is some of the data being...
  17. metalteck

    If Statement

    If I use the formula: ({@Discharge Date}-{@ADM}, it results with the number 730487 and is a number type. If I use the formula: date({@Discharge Date}-{@ADM}, the results are in date format, with the year showing. Ex:1/1/00 How can I only show the difference between days?
  18. metalteck

    If Statement

    Here are what the formulas look like: ADM = Date ({BADPLPP.LPADT3},{BADPLPP.LPADT1} ,{BADPLPP.LPADT2} ) DischargeDate= stringvar MyDate := totext({badplpp.lpldd},0,""); if len(MyDate) = 5 then cdate(2000+val(right(MyDate,2)), val(left(MyDate,1)),val(mid(MyDate,2,2))) else if len(MyDate) = 6...
  19. metalteck

    If Statement

    Crystal 8.5 I have 2 formulas that will tell me the difference of days between them. date({@Discharge Date}-{@ADM}) ADM DD Stay 7/25/06 7/26/06 02 1/13/06 30 I changed the format options to a custom, so that it would only show me the number of days.When I display...
  20. metalteck

    Date Comparison

    The 3 fields that make up the 2 date fields are number types. Right now the query looks like: TransDate SvcDate 3/10/2006 4/10/2006 4/15/2006 1/21/2006 I want the report to be able to look up through the dates and only pick the dates where transdate is greater than svcdate.

Part and Inventory Search

Back
Top