Search results

Hi again Steve Nice to know your first name. I think that you have given me the answer. I will try playing with the size of the plot area vs the chart area, I think that might do the trick. Thanks very much for your help. PeteB

Sneuberg Here is attachment...

Dear Sneuberg Thanks - please see attached screen shot. Left hand image shows pie chart with the upper left data label with characters side by side, as I like it. The lower right data label has characters in two rows. The right hand image shows the bounding box of the lower right data label...

I have been trying unsuccessfully to re-size the boxes which contain data labels in an Access chart. I need the data labels to show value followed by %, separated by comma and space, with all characters side-by-side (not value above or below %). Pre-edit, some of the labels have characters...

Hello Ranman 256 Thanks for such a swift response. This is exactly why I can't understand what's going on. The query is a simple query, not an action query or a parameter query???

I am running Office 2016 and have endeavoured to write a query which returns group members who have not resigned or died and use it as the data source for a mail-merge to produce mailing labels, but cannot successfully merge when initiating the process from Word. In a query called 'Address...

I will give it a try. Hello Sneuberg, Stripped down database attached as JF4.4n. Hope you can do something with it. PeteB

Hello Sneuberg, You are correct, I tried your fix and although the three remaining Payment Types showed up in datasheet view of the query, they all had the same 'CountOf MemberID' of 1, which I did not understand, and when I attempt to produce a pie chart based on the query, Access presents a...

Thanks Sneuberg, That sort of works. There are 7 Payment Types of which only 3 currently have data entered in the Payment Type field. Your solution correctly returns records where the PT field currently holds data but ignores the majority of records where the PT field holds no data. Even if I...

Payment of club subscriptions can be in the form of different 'Payment Types'. I need to create a query upon which to base a pie chart which illustrates the different payment types as a percentage of the whole membership but am struggling with the expression which returns a count of the...

Thanks Gasman, I'll give it a try.

I am running Office 2016 and have endeavoured to write a query which returns members who have not paid their membership subscriptions and use it as the data source for an e-mail mail-merge to send out an e-mail circular, but cannot successfully merge whether starting from Access or Word. In a...

Thanks Ranman256. I will give it a go.

I need an expression which, on a report, will sum the values in a currency field but ignores values which when previously entered have been marked in some way (e.g. placed in parenthesis or asterisked perhaps when entered):- What would be the best means of marking the entries to be ignored? What...

arnelgp Thanks for your input yesterday. I entered select * from table where [datefield] between DateSerial(Year(DateAdd("m",-1,Date())), Month(DateAdd("m",-1,Date())), 24) And DateSerial(Year(Date()), Month(Date()), 23) into the DateJoined field but am told there is a syntax error. I have...

I need an expression to enter into a "Date Entered" field of a report, or into a query, to return a set of records between 24th of the previous month and 23rd of the current month. Can anyone help please?

I have limited experience of Access but like tinkering.

Hello from Northamtonshire, UK