Recent content by sspayne

Thanks fneily, that was the sort of thing I had in mind when I posed the question. Part of this whole exercise will be illustrate to the guys commissioning this work that their data collection and storage techniques need huge improvement. At least I can try and give them a short term solution...

Thanks, I think I understand the point. The situation I have is that the first table contains all addresses in the county plus some attributes for each address. The second table is a set of customer addresses and the services they use. I wanted to, in effect, join the attribute data in the...

Hi all, apologies for probably dumb question - haven't used Access for a couple of years and out of practice! I have a table containing addresses. Two of the fields are [street] and [postcode]. Values in either can be duplicated, but when they are combined they create a unique value. I have...

Ignore that last one!! No longer greyed out. It works, and I'm a happy chap. Thanks again for your help and enjoy the purple star. SS Payne

Again, thanks for the quick response Ken. This is incredibly frustrating - I know now what I need to do, but the References option under Tools is greyed out so I can't make the necessary changes. I expect that will be to do with the installation? I suspect I'm on my own with this one now...

Thanks Ken, that has certainly progressed it a bit. As you suggest, I have built the function into a query. Next problem! It flags up an error within the function at the line Dim rst As DAO.Recordset (user-defined type not defined). I think I have read elsewhere that this may be because the...

Hi all, I can only apologise for posting what is a really basic question, but they've just sent me on an 'Intro to Access' course and I am now expected to solve all their problems. Here I go: how do I actually make use of a function? I have copied a Public Function taken from a FAQ into a...

Not really! I know what it is and have pasted other people's scripts into by db before, but certainly not an expert at writing VBA from scratch. I think if someone could tell me if there is a way of listing all dates between a start and end date then I could make use of your original suggestion.

Thanks ChaZ. At the moment I just have start date and end date, and a datediff query works out the total number of days off sick. I would like to use your approach - is there a way around this? Thanks again.

Some advice please for an Access novice. I have a report that calculates the total number of days that employees spend on sick leave grouped by quarter (based on first day off sick). I need total sick days per quarter but have trouble when an employee's sick leave spans more than one quarter -...