Search results for query: *

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)

I got an Excel file with text (customer names), made on a Mac, don't know which version. Open it in Excel (Office 2000 Pro on Win 2000 Pro). A weird thing seems to have happened. Every instance where the letter R preceded the letter T, the R is deleted and the letter C is inserted after the T...

Indeed a tough question and maybe one that doesn't make sense.... I have seen folks with little to no knowledge of databases getting along the FileMaker logic in no time. And folks with an CS degree, after months still do not get the basic into their fingers/head. The videos, although not...

My Win2k machine is happely humming next to my 2003 server and my Sony with Vista. I do all my developing on the 2000, without any problem. I see no need to change yet. Sure, some programs will not run on the 2000, but they will on the 2003. And if not, I have the Vista. Or I bend and tweak...

Indeed a lot of info. But it's not enough. Let's go step by step. = which version of FM do you use. Possible techniques will be different. >> 3-Art director decides if a "New Product" has to be created How ? Is it a specific button, a given procedure? To build your sequence number/letter...

Or, going further on lebisol's idea, you can search for the 'missing serials' first and create a records using the missing numbers first, before adding 'new'.