Monthly Statements

[bigfatgreedykat]

Hello all

This is my first post i'm very new to FileMaker started this week!

I learnt a lot from a book. However, i'm now stuck!!!

I require a statement for invoices showing how many per month with totals.

I'm sure this can be done but how?

Look forward to any replies and thanks in advance for any help.

BFGK

[mr_vodka]

Hi BFGK and Welcome to the forums.

If I am understanding what you are looking for, you could use a subsummary report to achieve what you are looking for.

try doing a search for +summary report or +subsummary and you will find tonds of examples on here.

[bigfatgreedykat]

Hello John

I've got the summary working and understand what i need to do.

However, my invoice date inserted is in the format 23 Jan 2007.

I've inserted a MONTH field in table but cannot seem to format as month name only i.e. Jan

Any ideas. Can i auto format the MONTH field from the invoice date field?

BFGK

[AudioFreak]

Use MonthName(Your Date field) Make sure the MonthName field is a Text Field.

Michael

[bigfatgreedykat]

Thanks that works

But when i create a report to summarise by Month it doesn't work.

It is sorted alphabetically but it's definately in the format i require except date sorted.

Any ideas

regards

BFGK

[comment]

See if this helps.

[bigfatgreedykat]

I entered formula but its states the function cannot be found???

[comment]

I am guessing you did not replace DateStamp with the name of YOUR date field?

[bigfatgreedykat]

I change to date field named DATE

Now its just a ?

[comment]

I don't know - I cannot see what you are doing. Compare yours to this:

[bigfatgreedykat]

Thanks

It works great!!!

Is it possible to sort the invoices numbers under the Month?

I really appreciate all your help, thanks again.

regards

BFGK

[bigfatgreedykat]

Hello all

I sorted the above problem out!

Thanks again for all your help

regards

BFGK