Hey there all. I hope I am posting my querry in the right area.

I am adding to what i have built for my road manager

reports. I'm learning how to put this all together as I go, so if you can help please use beginner terms. I have just started working with calculations and it seems to be going pretty well, considering I didn't have a clue how to make them work. By calculations I mean mathmatical functions, by the way.

My question is this:

I have rebuilt my settlement spreadsheet from excel into filemaker so that I can keep track of how many people paid, comp tickets and what my band actually made that night. My filemaker layout is almost identical to what my excel spreadsheet looked like. Is there anything I can do to have my filemaker layout save to an identical excel layout?

This would save me from going back and re-entering all the information I gathered in filemaker.

If you can point me to a tutorial or a book to purchase that would be great.

Hi SOUNDGUYRIC, and welcome to the Forum.

You can export as Excel, or Save a copy as Excel.

Have you tried either one? They are located in the dropped down menu under [color:blue]File.

Lee

Yeah, i just went back and tried that.

When I open in excel its not formatted, it just shows up as a long line of fields. a1 thru a cc

for example.

Should i have done this in table view mode or something? I built it in a blank form.

"Not formatted," how?

Do you mean that the calculations didn't come across? That is normal.

Read about the different file formats, and what they will do, and won't do. Start with this one from Online Help.

Saving, importing, and exporting data > Supported import/export file formats > Microsoft Excel format

HTH

Edited February 25, 200817 yr by Guest