Recent content by stopher

Unless I'm misunderstanding the problem, then to calculate the average payment period in months then you just need: ( (Last paymentment month) - (first paymentment) ) / (number of payments) This is easy to calculate from queries or dlookups. I don't understand how you calculated...

Hi Doc. Yes I agree it's a category I wasn't which to put in. Maybe I should have put it in the water cooler lol. Thanks for everyone's wishes and sorry for not updating. I've been PM'd so I thought I'd give an update here. My condition has been kept quite stable since initial diagnosis and...

It's a ludicrusly trivial point i know but I think OOP is generally stands for and is pronounced as "Object Oriented Programming" not "Object Orientated Programming". I guess it stems from the American phrasing of orientated (?).

Your circular error is in cell K23. The formula in this cell is =23:42191 whatever that is supposed to mean. If you delete this formula then the circular reference disappears. What were you trying to achieve with the formula in K23 anyway?

When you look at the link provided by plog, you will see there's an option to link using a connection. I highly recommend you do this. i.e. open a new spreadsheet and create a "connection" to your chosen table/query/database. This gives you seamless connections to the Access data (just by...

As CJ mentioned, you can only have one column header. But you can quite easily create a new pseudo header by concatenating the two fields you want. So in your example if you have a field called Criteria (e.g. Crit 1, Crit 2 etc), and another called Letter (a, b c). If you then create a new...

Not sure if this is the best section to post this but here we go.. About four years ago my neighbour was diagnosed and subsequently passed away as result of a fairly rare cancer (mesothelioma). I’d not heard of this before but not long after it was announced that, one long term forum member...

Sounds like you what to use UNION so that you stack the results of your query with those of table 4. Google union. But it's not normal to union data of different granularity so might be useful to understand why you want to do this.

I agree, Access is sadly lacking in a datagrid view (akin to Excel view). The datasheet view doesn't even come close. Some applications are well suited to grid style view for user interaction, even if behind the scenes the data is stored in normalised tables.

The solution I provided implements the required constraint on the table. You only need to run the SQL once because when you run it the constraint will be implemented in the table and will remain there. Once implemented, you won't be able to add reversed words regardless of how you add them to...

An alternative option is you can add a constraint to your table like this: ALTER TABLE tblWords ADD CONSTRAINT ckWords CHECK ( NOT EXISTS ( SELECT * FROM tblWords AS t WHERE t.Word1=tblWords.Word2 and t.Word2=tblWords.Word1 ) ) ; So the above only allows you add/change a record...

Why do you say the OP is using Excel thinking. As I see it the OP it describing a real world problem i.e. the calculation of charges are dependent upon a charge type (which presumably can be create/edited by the user). This pops up often in the real world e.g. taxes, VAT where the formula is...

Selecting "Enforce Referential Integrity" is enforcing mandatory participation i.e. if I put a vlaue in this table then it MUST exist in the related table. But you may want optional participation. Consider a car booking system that books from cars in their own fleet but also occasionally books...

Maybe you could post a copy of your table in a new database and post here. The problem with this sort of problem is we can't see where you are starting from so make assumptions.

I made some changes to the schoolid combo (event) and the sessionid source. See attached