Replies

Hey, I’ll give that a try and see if it improves matters. Unfortunately, I still need to use Word, even though it’s PANTS!!

Tops, cheers.

Cheers.

Top.

Great, thanks – and sorry about the delay in acknowledging. I didn’t use ‘Chapter 1’ as my text, and so first inserted a reference to the ‘Headling Text’ – I then had to insert a second reference to ‘above/below’. A more challenging question is how to create my own version of the words ‘above/ below’. For example, ‘discussed earlier/ discussed later’. Could this be done with an IF Field??

You are right, but I don’t think that this resolves the problem. If you do this then it converts to a pie chart. I think the solution remains to use a radar chart.

Excellent!! I used the filled radar with lots of duplicated values to force the series into circles. All I needed to do then was change the Series order and the fill colour for each one, and remove the labels and axes. Whe’hay! Thanks very much..

The hole in the doughnut can only be reduced to 10, not zero. This would be okay if I wanted to treat the hole as a data point, but I need to shade in the hole (which Excel treats as the Plot Area)! Any other ideas? Is there a different chart type that could be ‘co-erced’ into looking like a doughnut (without a hole?! – which I suppose is a bun?) Andy.

Excellent.

Hey, that’s cool!! Cheers Charlotte. (Sorry about the delay in responding).

I didn’t really understand the answer. I initially created a query which includes a calculated field. I used rnd() and tried to supply a seed using the Now() function. However, it continued to create the same number each time. E.g. RandNumber:Int(Rnd(Now())*20+1). I also tried a Make Table query using a Random AutoNumber but this doesn’t work either. Can anyone suggest why either of these doesn’t work?

Although some companies may share the same address, this is more of a coincidence than anything central to the design of the database. Any one contact is, in general, based at a particular address for a particular company. Although in theory the same contact may occur for different addresses and/or companies the likelihood of this is extremely rare.

Therefore, I am still unconvinced of the need for a join table. What problems are likely to occur if I don’t use a join table? Andy.

Thanks very much Charlotte. A join table has not been used, and you have described what I have been doing to get this to work.
Any one company will have several addresses. At any one address there will possibly be several contacts. The contacts could also be the same for several different addresses. ALSO, it is possible that several companies may give the same address, just to complicate things!
Could this set up work with a join table and why would it be preferable? Andy.

Thanks. I’ve got it to work, in a roudabout way – although I still don’t fully understand what the problem is.

In Excel I have a list of companies together with several addresses and in turn several contacts. I was hoping that Access would be able to ‘recognise which company we are referring to, add the addresses to the addresses table (together with the correct companyID), and similarly add the contacts (and correct addressID) to the contacts table’ – in one or two steps!

It seems so simple when explained in English. Anyone willing to have a stab at trying to explain the problem?! Cheers, Andy.

The Excel data is in a flat-file format. It includes the company name, an address and a contact on one row. The company name is then repeated for different addresses and different contacts.

I want to add all this data to the three relevant tables. If the company doesn’t exist then a new record is created for it.

Any one company may have several site addresses, and for any one site address there may be more than one contact.

Hope the above helps?!