Thanks Leslie. That's exactly what I did in the first place. The join on the query using groups and aggregates make the query so it's not updatable. I understand why grouping records does this, but can't find a different way to do it.
It might be that I have to live with it until the database...
Thanks again. It looks like it's in the right direction, but I get an error on that (syntax error in from clause). I can't work out what it should be.
Access97 by the way if that makes a difference (should have mentioned that in my first post).
I'm getting slightly frustrated at not being able to do what I want, but I do feel like I've learned some things in in trying.
What I want to do, is display the most recent date for each reference and letter type. For exmaple a table like this:
Reference LetterType LetterDate...
An outer join for no other reason than that's how it was before. It is possible to have records in the customer table, where no records exist in the letters table, but these wouldn't be displayed anyway so it's not necessary. Again, I've changed very little since the database was handed over to...
I've searched the site, and not found anything that really helps. I have a partial solution - I can return the records I want, but that then causes other problems.
To give you a bit of background, I'm maintaining a database that isn't my design, but I will soon be replacing it, so I don't want...
Although it might not give you detailed information, I just do a check for the record locking information, so something like:
If Dir("database.ldb") <> "" Then
MsgBox "Compact failed. Please make sure all users have closed the database before compacting"...
Hi,
I'm trying to create 3 temporary queries, using createquerydef, the third of which uses the first 2 queries for it's source. That seems to work without a problem, but i want to append the results to a table.
When i try to create a further temp querydef to do this, access tells me the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.