Search results

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...

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...

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...

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...