Search results
-
K
Putting multiple query results into one table.
Using Access 2007 I have constructed fifteen queries that are modeled like this: Query Name::PS_One SELECT CName, COUNT(CName) AS PC FROM Contact WHERE CType=1 And EDate Between Start_Date And End_Date GROUP BY Contact.[CName]; Query Name::PS_One_Total SELECT Count(PS_One.[CName]) AS ["PS"]... -
K
Calculations with query or vba.
Hello, ::USING ACCESS 2007 I am trying to perform a calculation on the results from 2 queries. Below those 2 queries are labled query_2 (derived from query_1) and query_3. I would like to take the result stored as PT in query_2 and divide it by CCount and then store the result so that it can be... -
K
How to make a calculated field using a query not in the report.
Hello, I am trying to make a calculated field on a report that takes a number generated by one query and divides it by another number (obtained by another query) and display that number as a percent. I am having trouble finding the correct function to get this done with. It should look... -
K
changing object visibility state after changing records
Hello, I am trying to make a form that only has certain fields visible based on a selection within an option group. I have a script to change the visibility states based on what is selected. Private Sub ffoVis() Me.EventDate.SetFocus Me.lblPackRecv.Visible = False...