Search results

Thanks for your help - good Idea. Nifty

Thanks nifty

How do you find the maximum of four fields in each record of a query. Say (for example) you have daily records of the rainfall across four cities, where the cities are the fields in the query. how do you write an extra calculated field to the query that shows the max. rainfall across the fields...

Thank you for your well thought out reply. As I am new to Access I will have to study it to see if it gets me around the problem. The car /cost problem is really a simplified version of a problem I keep running into and as such I am very interested in your solution. Thanking you again. Nifty.

I have what appears to be a simple puzzle. This is a simplified version of the real database. The purpose of the database is to act as a simple calculator - in this case to find the cost of a journey in a specified car to a specified city. There are 4 tables. Table1(input Data)with 2 fields...

Thank you for pointing out table labelling error. I have corrected the error in the original script. Any idea how to get around this problem. The problem always arises when information from 2 separate tables is needed to lookup a third table in a query. This is essentially the hub of the puzzle...

I have what appears to be a simple puzzle. This is a simplified version of the real database. The purpose of the database is to act as a simple calculator - in this case to find the cost of a journey in a specified car to a specified city. There are 4 tables. Table1(input Data)with 2 fields...

Tried solution Thank you for trouble you took to write the suggested solution. I copied and pasted the SQL into the query and ran it: An unexpected Input box for TableTwo.Focal spot came up so I Put Square brackets on the Focal Spot in the SQL script. The Script is now: SELECT...

I have a simple database with 3 tables. Table 1 has fields "Phantom" and "mA", Table 2 has fields "mA" and "focal spot" where "mA" is the primary key. Table 3 has fields "Phantom", "focal Spot" and "detector factor" where both "Phantom and Focal Spot are set to primary keys. What I am looking...