Search results
-
T
Calculate Median
I am attempting to calculate the Average & Median on a particular field in a query. =Median("qry2007_KPI_AvgJan_A","ContractSignedToReceived") query name is qry2007_KPI_AvgJan_A field name is ContractSignedToReceived I am getting #Name? error. Any ideas why? Thanks for any help... -
T
Grouping For Output to Email
Hi there, I have 2 parameters that I need to group by... by Install SP and by Line item. I want all Line Items that have are linked to an Install SP to be grouped together in the email. I am able to get the data grouped but the Install SP is duplicated in the output. An example of what I...- tmercier
- Thread
- Replies: 1
- Forum: Modules & VBA
-
T
SQL statement in VBA
I am attempting to edit code that was written by a different developer (I'm not familiar with SQL) to include a field from another table 'tblInstallSummary'. How do I edit the SQL statement to reflect this? I've bolded my attempt below but I am just getting an error. Thanks to anyone who can...- tmercier
- Thread
- Replies: 22
- Forum: Modules & VBA
-
T
appending to end of Line description
I am wondering if it is possible to use a wildcard in an update query. I would like to add text (the same word) to the end of the line item description where the starting text values are different. example: want to add Quantum beginning value is:Trendsetter II -> new output value would be...