Recent content by JeanW

Thanks. Works like a charm. Didn't even know that function exist. But then, I nearly never use Excel, only when forced to.... Tx

Hi all, I have an Excel file with comma separated data in cel Ax, going down to 900+ rows. To have it easy to import the data into another program, I need each cvs part into separated cells. Parts can vary from 4 to 7 between commas. Ex. A1 has data xxx,yyyyy,zzzzz I need xxx in cel K1 yyyyy...

Seems to be a Mac problem then.... Sorry, only all other OS here (Win, Linux etc )

The OP wants to know: 'TOTAL of each product ordered' not the price. You can use other functions to capture the total price through the relationship.

What is 10.6 ? Vague question with strange denomination....

If you have a relationship between the products and your Sales campaign, use this to make a foundCount on each product. This calc will give you the total of a product based on each campaign.

Like your modeling is now, it will never work. Basically you're talking about a many to many relationship. To solve this you need to transform this to two one to many relationship.

You have a date function Date(month; day ; year). Within this function you can play with + or - months, days or years. See if you can accomplish what you need with this function.

FileMAker Pro 2.5.... Are you sure it is 2.5 ?

Sorry. I missed this for while. Do you have a solution yet?

Starr Data had once a program like that on their site. I don't know if it is still available. Maybe if you contact the owner.... http://www.starrdata.com

What is your If() statement ?

Short and quick. >>I give them a database.... Put in that database a timelimit date, together with the current date, nearly hardcoded. Let your upstartscript check for the first launch of the DB by the client, store that value together with the systemdate, which must be greater than your...

OK, after a few more questions to the other side: The data is an Excel file made on a Mac (don't know which OS)in MS Office for Mac 08 ( ? ) with data coming out of an Access file. I have no idea how they make the Excel file, just export or save the data as Excel, I don't know. And they can't...

oops......silence.... Euh...no... But I did now, and can't find anything.... (will put that in my 'to look for...' file, thanks)