Search results for query: *

Got it to work, Thanks again BB

Oh, How do you call the functions?? I tried BOMONTH(2,2006) got an error??

Thanks BB A star goes your way GG

I am needing some UDF's that will return the 1st and last day of the month for a given month. I had some written in FP2.x but they no longer function correctly in VFP9, I think since dates are handled differently. I could rewrite them, but I thought someone may have already done this or maybe...

Thanks for the replies.. I think I will not add the tables to the project just to be safe.. Oh and while we are on the subject, what happened to BUILD EXE STANDALONE no more standalone??

Duh, I hadn't thought of it. Thanks

I have a simple form that runs 1 report, creates a couple of free tables and accesses some other tables which are part of an another application (written in foxpro). The other tables are associated with databases. I need an executable that will run with the vfp runtime files on another...

I have a weight field for which I would like to a "#" (pound) sign to the end of The existing mask is 9,999,999.99 When I make it 9,999,999.99# it just adds a decimal, which is expected since the pound sign is a valid character for the mask..

Worked Fine! Thanks.. Again does anyone know of a good reference for MS Access SQL. The help doesnt seem to have much..

Worked fine , but I need the opposite. WHERE 1st character of last name NOT equal to * BTW, is there a reference manual for MS Access SQL (it does not seem to be compliant with other SQL's) Thanks

I'm trying to do a simple query on an employee table named Workforce1. I need to filter out all the records where lastname starts with an "*". I need help with the WHERE clause. This is for MS Access. Is this possible? SELECT Workforce1.EmployeeNo, Workforce1.LastName, Workforce1.FirstName FROM...

Thanks, did the trick..

I have created a report using the report wizard from a free standing dbf. I create/update the dbf from an excel spreadsheet. It seems the report is using a VFP data environment where it automatically opens the associated DBF/CDX. When I update the DBF from excel and try to run the report I get a...

Thanks for the reply, yes I figured out that you need to multiply the totaltime field by 24 to get a numerical value that you can calculate on. I got the clue from working with time in Excel where you also have to multiply by 24. Thanks again.

Sample Data JobNumber Department Time (Hrs) 2005 3 9:00 2005 3 4:15 2005 4 2:45 2005 4 12:00 2006 1 8:00 2006 1 8:00 2006 2...

It is indeed a duration of time which I am storing. and also I do have what you mention as a control source e.g. =Sum([TimeField])in the group footers. As I describe the data type of time is "date/time, Short Time" There are other fields in the original table such as 'Time In" and "Time Out"...

For some reason I cant get this simple report to work, am I missing something? I have simplified the info for easy reading. I execute a query on a table to get the following datasheet. Table (datasheet) Field Data Type JobNumber Number, Long Interger Department Number, Long Interger Time...