Search results
-
P
syntax for select case conditional statement
Problem : I get red colored on Select qry.Parameters("QuarterBeginDate").Value Question: what kind of statement should I use for correct syntax? Code: qry.Parameters("QuarterBeginDate").Value = [Forms]![Run]![QuarterBeginOrderDate] qry.Parameters("QuarterEndDate").Value =...- pke8jt
- Thread
- Replies: 9
- Forum: Modules & VBA
-
P
top 3 customer but one of them is sum of multiple parameter
Question When generating a top 3 customer result, Is it possible to include a sum value in it? my current query: Sum of Dollar | Customer 10 | A 8 | B 5 | C desired query output 14 | B_Total 10 | A 5 | C B_Total (14) is the sum of X (4), Y (3), Z (2) AND B (5) And [History.CustomerNo]... -
P
sudden compile error in query expression, IIF
Hi, I used an actual aggregation function in my IIF statement, so that my query at execution time know what the column SumOfDollarsSold is. Then I get compile error in query expression, 'IIF(ISNULL(Sum(dbo_SO_SalesHistory.DollarsSold)),0,Sum(dbo_SO_SalesHistory.DollarsSold)'. It is bizzare... -
P
How to effectively create/run many vba modules with static values
General explanation: Users input start date and end date on a form that filters my query 2_Total (single value) e.g. 154,21 (one of my query image attached) Run the VBA function that exports the query to an excel file Current set-up I designate static values to each module (row, column and... -
P
MS Access OpenRecordset parameters and too few parameters issue
I'm certain that I have enough parameters, fields declaration to pass values to OpenRecordSet method but I am still stuck. General explanation: Users input start date and end date on a form that filters my query 2_Total (single value) e.g. 154,21 Run the VBA function that exports the...