Search results for query: *

Thanks jrbbldr - just what I need, much appreciated.

Thanks jrbbldr for the prompt response. I take it from your reply that there are no "tools" available that could convert/re-generate the FPW 2.6 code in to another language, other than VFP. Sorry to labour the point.

Hello All, Can anyone definitely advise whether there is a "code" migration path from FPW 2.6 to non-VFP language e.g. VB, C# etc. Many thanks.

Try checking the Print When > Remove Line if Blank option in the memo field on the report. Regards,

Thanks Skip.

I have no issue with pivot tables and agree wholeheartedly with your comments about their usefulness. However, this solution leads me in to a world of hurt supporting one of our most computer illiterate users; a single formula would have made my life easier. Purely selfish motives, que sera.

Thanks for all your help, I have ended up having to use a pivot table as you suggested.

Oh, thanks but that's not really what I want. I want to analyise the column and identify how many instances of each name there is, and then summarise that information. e.g. JOHN and TOM only appear once, so there are 2 instances of a name that only appear once. ROY appears twice, so there is 1...

Thanks for your reply Skip, not sure I follow though!

Thanks for your replies. I was hoping I could do it without using a pivot table. I have tried using =COUNTIF(A1:A8,A1:A8) and can count instances within the data but I want to summarise the number of instances within a number range. i.e. the number of times a "name" appears only once the...

I have a column of data and need to count the number of times a record apears within a range to a summary output. Something similar to the following... BOB BOB JOHN BOB TOM BOB ROY ROY Summary output... Equal to 1 = 2 (i.e. JOHN and TOM) Between 2 and 3 = 1 (i.e. ROY) Greater than or equal to 4...

Is it possible to open a bitmap image in a report using a named expression or macro substitution? e.g. m.image = flag.bmp Report Picture dialog box, file option [(m.image)] or [&image].

Problem solved, pure genius Rick. Thanks to all you guys who replied. I noticed that a couple of you used alpha extentions in the FROM clause (i.e tableone a), as do some of the examples in my FoxPro manuals. Is this standard protocol or are there benefits to be derived from it? Does it assist...

Thanks for your replies gents but unfortunately none of them solved my problem. DSummZZZ and mlv1055 Both solutions output 11 records (I am expecting 6) The WHERE clause associates tabletwo.table_name to each tableone.table_name three times. I have tried WHERE (tableone.table_name =...

Can anyone help me with the following problem? I want to be able to output all of tables ones contents plus associated table two contents using SQL. Example... TABLEONE table_name field_name STAFF STAFFID STAFF NAME STAFF JOBTITLE CLIENT CLIENTID CLIENT...

Eslersa, are the lag-times specific to FoxPro? I had similar problems accessing/opening files across my network, regardless of application, and resolved it with a registry fix (FoxPro is back up to speed). I am not sure if this is the most suitable place to post it but…let me know.

Cheers Rick, you are a star!

Thanks for your reply. After a quick investigation I discovered that the Build Executable is greyed out in the Project Build dialog box so I guess that I have the cheaper version? (however, Build Application is selectable). FPW Help refers me to a Distribution Kit? I think I’d better make some...

Rick, Do you have a view on what would be the most sensible version of VFP to try and upgrade FPW2.6 to? Can I jump directly to V8.0?

Thanks Rick, I don't pretend to be a programmer (well, sometimes jokingly I do) and have inherited a number of workstations that have the full version of FPW2.6 installed. The numerous bespoke systems that we have running are located on a server and are called by each workstation using a...