Search results for query: *

Thank you very much for your help. Rt

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.

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

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

Thank you all for your help. rt

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

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...

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...

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

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

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

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...

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...

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

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

Thanks. I will try that. Rt

Hello all. Is there a way to replace 1 character with another in a field? (ex: replace a " with a - ). I am trying to copy query results from Query Analyzer into an Excel file and one of the fields has a double quote (") in it and it is throwing my paste into Excel off. I would...

Thanks. I will try that tomorrow morning. -Rhonda

Hi. I am having a problem with one of my offsite locations. The application is written in VFP 3. We are moving to an ASP application with a SQL Server backend, but I have to keep my locations up and running on the VFP 3 until the move. My issue is they are trying to print from the...

Hello. Below is my situation. Any ideas are greatly appreciated. My situation: I have several SQL scripts that need to execute on a daily basis. I login via VPN to a remote location and run programs that connect to a SQL 2000 database and pull the needed data. My problem: I would really...