Query, Form, or Report to a word doc table

[cowboy]

I have a database set up where the information is stored in tables and inputed through Forms and displayed on a Report. I also need additional tables from this information that I will be going into word document tables. Some of the information will need a little manipulation such as IFF(A>B,A,B).



My question is should I be setting this information up in a query, form, or report if I am trying to copy it to a word document table?

[jbarrum]

I believe a query is going to be your best bet. Just build a report off of your table and add your expressions to the query.

[cowboy]

Ok well I am trying to make a table in the queries and this is what I have so far

TRANSFORM Count(InspectionsDI.DropInletType) AS CountOfDropInletType
SELECT InspectionsDI.[Drop Inlet Type], Count(InspectionsDI.DropInletType) AS [Total Of DropInletType]
FROM InspectionsDI
GROUP BY InspectionsDI.[Drop Inlet Type]
PIVOT InspectionsDI.ID;


This will work and I could just copy the first 2 columns, but the perfectionist in me wants only the first 2 columns to display instead of every time it counts a Drop Inlet Type, any help?

[jbarrum]

Could you just build a 2nd query off of that query that only displays the fist two fields(columns).