adambern

Thank you - I'll try that later!

Can I ask how you'd construct a calculation for the date of the first day of the month?

Got it! I just needed a second sort order field in the layout... Month followed by date. Thank you for your help.

It's grouping by 1/4/2020, 2/4/2020, 3/4/2020 and so on and subtotalling each. I'm trying to get the report to put all of the results of (say) April in one block, ditto for May... So, dare I ask, how would you configure the report in my last post?

But isn't that what I've done? Month is the only field in the part and it returns (say) a load of 'April's. The problem is that FM is still picking out the individual days. See attached.

Thank you for the quick response but the file Report_Date is not mine, it's the file I downloaded to see how the value fields work. Unless I'm being particularly dim - it happens - I cannot see how the value field has been deployed. As you say, the button on the sample table works... I just can't see how! The main issue... on the report *page* that I uploaded (with the redactions), is that I can extract month from the date field. But when I try to group (via inserting a part) to get a subtotal per month, I get subtotals per day. Thank you for your attention.

My first post on FM Forums so be gentle and don't flame... I'm desperate to ditch MS Access and a virtualised window on a Mac. I've created a new DB from data exported from Access - that's all good. I've got lookup working and summary fields working. I can also generate month and year fields via a calculation from a date field. But for the life of me, I cannot get the report to group *all* records from a given month in one block, no matter what I try. Instead, the report insists on grouping by day. The attachment 'Table' shows the table I've created. 'Report' (excuse the redactions) shows the problem - column 1 is the invoice date, 2 is the client (redacted), 3 is the item sold, 4 is the invoice number, 5 is the gross (redacted), 6 the VAT (redacted), 7 the net (redacted), and 8 the date the invoice was settled. I saw one post where a value list was set up for each month (see Mr Vodka in the link below) but when I look at the example I cannot see how to deploy the value list in the example he gives. So... quite simply, how do I tell the report to lump, say, all invoices for April in one chunk to subtotal, and so on for other months? ) Report_Date.fmp12

Any ideas: I've finally ditched PC for mac. I'm still using (for the moment) Virtual PC for Mac and MS Access but I want to move fully to FM8. My problem. I've exported my Access data via ODBC into FM8. Some Tables are fine as they're standalone. But I'm having real problems with linked tables. I can easily get linked tables to show information from all appropriate (imported) tables, but the whole thing falls over if I try to add new data. By this I mean that I can see all of the old imported data but new records will not populate those imported fields. And vice versa - I can add new records by defining new fields and populate those new fields but I cannot see the 'old' data. For example in my 'stock' table, I have ID fields for Articles (adid), Magazines (magid), and Writers (writeid). My stock table links to Magazines, Writers and Adapts to pull over the detail Stock needs as each of these tables has the fields I mentioned earlier plus other more detailed information. So, with these links I can see the old data perfectly, but if I try to add new records the data from the linked tables doesn't appear. I hope I'm clear with this - it's all getting a little technical now. Any ideas? I'm reading "Filemaker Pro 8 The Missin g Manual" but I'm still lost. I've attached the file - I've had to remove most of the data since it contains personal information. NewDB_copy.fp7.zip