Recent content by The Thing

With regards to my first post on storing calculated values in a table as opposed to generating the values on the fly for queries and reports etc, how much consideration should be given to this when designing a database. I ask this as I am using a commercial application - [Visual Basic front end...

Thank you Mile-O-Phile, thanks for your help, worked as you said it would.

I have Access '97 running on a Windows 2000 machine and lately I have begun to see tables apparently generated automatically in the table view of new or existing DB's. In comparison to ordinary tables created by the user they appear to be slightly greyed out. Are these a normal part of Access...

Syntax error I've tried running the SQL in the first part of your post , but I'm getting an error which says "Syntax Error In From Clause" Below is the query copied from Access SELECT Transaction.* FROM ( SELECT Transaction.Registration, Max(Transaction.TransactionDate) AS...

Thanks Thanks namliam, I'll see how I get on with implementing your suggestion.

Hi There, I have a table in an Access '97 database called Transactions, which includes the following fields: TransactionNumber, VehicleRegistration, TransactionDate, - for example [02/01/2003 09:58:06] Waste, NetWeight. Multiple transactions may occur for the same vehicle each day at...

Is it possible to place comments in your SQL code to make the reading of it easier? I'm using Access 2000.

One of the tables in my Access 2000 database has two fields in it called Units Purchased and Price per Unit. How can I have access fill in a third field (Total Cost) in the same table automatically with a currency value that is calculated on the values of the aforementioned fields as in Total...