Recent content by dalski

External good sir.

Out of interest how long until a user can post links? I think it is a good measure & is required, quite frustrating sometimes, I'm 50 or so posts in & still unable to link :eek:.

I'm just a learner but I believe queries greatly outperform dLookup; especially as it scales. I think you'd be better off using an update query. I don't know much about them but I believe an update query will only save/ act on the fields in which it makes changes so be forewarned to save as a...

To state the obvs it' snot worth effort repairing an 8 year old machine & my experience of most repair shops have not been fruitful & my own endeavours to repair electronics have failed miserably most of the time with very few success'. BUT it's probably all about the challenge for you...

Thank you very much.

Thanks @cheekybuddha , very helpful. Believe me not wanting to run, just trying to grasp the basics but spinning out of control lol.

Thanks @cheekybuddha, it works in PostgreSQL - direct from tutorial mentioned in specific area of Multiple Rows & Multiple Fields area of subqueries Youtube techTFQ titled "Subquery in SQL | Complete SQL Subqueries Tutorial". Thanks for your input on the qry. I just cannot see how I can learn...

Think I've ran into another flaw between native SQL & Access SQL. Access will not allow Multiple Row & Multiple field subqueries. Reluctantly I may have to quit the native SQL tutorials on Youtube techTFQ as it seems near unrecognizable in Access. A multiple row, multiple column subquery seems...

Thanks people., much appreciated.

Thanks @plog, interesting that the prompt from Access is incorrect; should have warned me about the join statement not 'FROM clause'. Grateful for the input on Alias' shorthand only in FROM clause.

Thanks @The_Doc_Man, I do not blame you for not downloading. Pasting in Notepad & Word I can't see any unexpected phantoms. I didn't have a primary key in one of the four tbl's as one of the tbl's didn't have an obvious PK (not related to this query). Putting a PK in said table (unrelated to...

A brilliant SQL resource on Youtube tachTFQ (great teacher) - BUT exactly how different is native SQL compared to ACCESS SQL? Richard Prost does not indicate a great difference & I would have thought semantically it would be near identical. Seems to have different datatypes, ∴ data-sizes...

Thank you all for your input, massively appreciated. Sorry @arnelgp, this solved it. I posted at a hectic time & forgot to convert the subqry on the margin% field to a dLookup. The interesting question is WHY does a dLookup solve this. The subqry seems near identical in it's format. Why did I...

Thanks both for help. I changed the subquery to a dLookup fn using the query designer (which I would imagine it yeilds the same result as altering the SQL) & sadly the recordset remains uneditable. I know the issue is caused by The qry is used in a form but also used in other uses so i need the...

Thanks @cheekybuddha. I'm unable to post links with SPAM restrictions. Do a search for "Using a Subquery in a SELECT statement; red-gate "Simple Talk by Greg Larsen". I think there are instances where a basic subquery will yeild a single result... 'set as a column value' if I'm interpreting it...