Recent content by coastguard

Thanks Pat and Jdraw. Both replies very helpful and not only for this question. REgards and hope the rest of your day?? goes well.

Hi, I've inherited a data base which has the address details of our members spread across multi fields i.e. Add 1, Add2, Add 3, Post town, Post code etc. Not all the fields contain information which means when I do a mail merge for address labels there are blank lines. I would like to...

Cyberlynx, I like your style. Having just spent a while trying to sort out three combo boxes I eventually did by following some pointers and a sample data base. It's good to find out yourself but helps to have direction.

Sue Powell, Thanks very much for your post. I've been struggling for a couple of days to get three combo boxes to link successfully and finally found this post and sample data base. Despite asking on the forum and getting some excellent help, I couldn't work it out. Thanks again

Thanks Wazz. It's working ok.

Hi, I've downloaded a database which creates cascading combo boxes; it's called CreateCascadeCombo, for which I am grateful to whoever took the trouble to create it. However, after it has done it's work and vreates the form in my own datbase, it says to make sure the latest DAO Object library...

Thanks JDraw, am printing it off now

Thanks Neil. I'd made a start following your last message and realised that it is best to use the three table as you suggested. Hope the weather in Newcastle is as good as here in Cornwall.

Thanks again. I don't think I'm doing a good job of explaining or maybe I'm missing something that's obvious to you. If I had one table which listed; (I presume this is what you mean by geodata) RegionName; AreaName; SectorName; StationName; Region1, AreaSW...

Thanks Neil. The data to be stored (in another table) will be the Station name, Date, Y/N for whether an inspection has been done, Pass/Fail, comment and possibly some other stuff I don't yet know about. I'll link the Tables on Station name so that I can get some reports based around Region or...

Thanks. It told me something I didn't realise

:confused: I'm setting up a data base so a friend can use it in a new job. He will be inspecting and writing reports on about 360 stations. The stations are a part of a large organisation divided into Region (3), Area's (9), sectors(65) and then stations. In order to use linked combo boxes...

Thanks, This looks like it might help me as well

OK, now i'm getting somewhere. I'm creating a new calculated field in the query and it seems to be doing what I want. Thanks for the steer Rich.

Sorry Rich, I'm obviously missing something or I'm not explaining myself too well. I have got a Totals Query to Give me a total for Worker A for each of the months April, May, June etc; Worker B for each of the months April, May, June etc and so on for the six workers. I now want to be able to...