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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by rtipton12

  1. rtipton12

    Calculate age

    Thank you very much for your help. Rt
  2. rtipton12

    Calculate age

    Hello. I have a birth date field and want to calculate the person's age. I know how to do this in VFP, but I am rather new to the SQL world. Can anyone tell me how to do this? BirthDate 1912-04-12 00:00:00.000 Thanks in advance.
  3. rtipton12

    Obtaining IP Address

    Mike, Thank you very much for your help. The last faq works for me. Rhonda Tipton
  4. rtipton12

    Obtaining IP Address

    Hello. Is there a way to obtain the IP Address of the current workstation using VFP? Any ideas are greatly appreciated. Rt.
  5. rtipton12

    Function to determine working day

    Thank you all for your help. rt
  6. rtipton12

    Function to determine working day

    Hello all. I have a program that needs to be run on the 5th working day of each month. Is there a function that will tell me which working day I am on? Any ideas are appreciated. Thanks. Rt
  7. rtipton12

    Copying to Excel

    My cursor has about 34,000 records Command: COPY TO file01 TYPE XL5 VFP Version: tried both VFP 3 and 7 My program copies a cursor to an excel file, opens the file, does numerous formatting commands and saves the excel file. Through some research I have found that VFP 8 will copy the file...
  8. rtipton12

    Copying to Excel

    Hi. I have several vfp programs that pull data from sql server using odbc and then copies the result cursor to an Excel file. My problem is I have a couple that are pulling 17,000+ records and only 16,384 get copied to Excel. Evidently this is a compatability issue, but is there a way to copy...
  9. rtipton12

    Using Count() in SQL

    Golom, I was able to incorporate your idea into my query successfully. Thank you very much for your help. Thanks to all of you for your replies. Rt
  10. rtipton12

    Using Count() in SQL

    Thank you all for your replies. I will try your recommendations.
  11. rtipton12

    Using Count() in SQL

    The only problem is that the example that I used is part of a bigger query in which I cannot put a limit in the where clause. Thanks. Rhonda
  12. rtipton12

    Using Count() in SQL

    Sorry, I did have the error type field wrong (it is a logical or Yes/No field) Facility # Error type 1 Mars Y Mars Y Mars Y Mars N Neptune Y Neptune...
  13. rtipton12

    Using Count() in SQL

    I am having trouble finding out how to do something in Access SQL. I have a query in which (among other things), I would like to count for a specific field is not 0. Example: Facility # Error type 1 Mars 2 Mars 3 Mars 0 Mars 2 In the query I will be grouping by facility...
  14. rtipton12

    Report form question

    Thank you very much for your replies. I should have known that. Thanks. Rhonda
  15. rtipton12

    Report form question

    Hi. I am new to Access. I have a written a query and would like to make an existing report look at my new query. I cannot seem to find the place in the report properties to change the data source location. Any help with this is greatly appreciated. Thanks. Rhonda Tipton
See more

Part and Inventory Search

Back
Top