Making tables: use query or report or what?

[cowboy]

Simple question, I am putting together some tables to be put into a microsoft word document and needs to be able to be edited. I am going to be getting this data from several access files with several records each so I was gonna make a query that I could copy to each database. Is this the best way to go about this?

If so in my query I want to get the greater of 2 values, I am new to queries and I can make the data in the record appear but I dont know how to evaluate between 2 numbers and choose the greater to be displayed.



Thanks for any help

[RuralGuy]

Probably using the IIF (Immediate IF) function in your query if I understand your post correctly. VBA Help will show you how to use the function.

[cowboy]

I tried putting code into the SQL view in the form I would use it in VB but it didnt work, gave me an error. Is there anywhere I can get an example of formats?

[RuralGuy]

It would go in your query.

[cowboy]

I tried putting code into the SQL view in the form I would use it in VB but it didnt work, gave me an error. Is there anywhere I can get an example of formats?

When I said that I should have used a different word other than form, it should read like;

I tried putting code into the SQL view in the same format I would use it in VB but it didnt work, gave me an error. Is there anywhere I can get an example of formats?

sorry about confusion

[RuralGuy]

Post the SQL view of what you have please.

[cowboy]

SELECT Inspections.ID, Inspections.[Manhole Number (12)], Inspections.[Manhole Type], Inspections.[Rim to Invert (13)], Inspections.[Wall Diameter], Inspections.[Wall Diameter 2], Inspections.[Additional Information (39)]
FROM Inspections;

and I tried

SELECT Inspections.ID, Inspections.[Manhole Number (12)], Inspections.[Manhole Type], Inspections.[Rim to Invert (13)],
if Inspections.[Wall Diameter]> Inspections.[Wall Diameter 2] then
Inspections.[Wall Diameter]
else
Inspections.[Wall Diameter2]
end if, Inspections.[Additional Information (39)]
FROM Inspections;

[RuralGuy]

Try:
SELECT ID, [Manhole Number (12)], [Manhole Type], [Rim to Invert (13)],
IIF( [Wall Diameter] > [Wall Diameter 2], [Wall Diameter], [Wall Diameter2]) As WallDiameter, [Additional Information (39)]
FROM Inspections;

WARNING - AIR CODE !!!