I'm having a problem with a subform that will not requery.
The subform is a datasheet that pulls price records based on a combo box in the main form. The query for the subform is as follows
SELECT AFL_CustomerPrices.Matrix, AFL_CustomerPrices.Test, AFL_CustomerPrices.Method...
Since it is a proprietary database, I cannot edit any existing tables. I can however add new ones.
Is there a way I could add a table that could allow the data to be displayed correctly in the query?
I have a frustrating problem that I could really use some help on (I'm not sure if the solution would be in the query or report) :confused:
Our company have labels that we print on samples for testing. We have to have a separate label for every dilution in a test.
What I need is a way so...
I am working with a LIMS database that prints labels for samples that will be tested in the lab. The lab has chosen to denote different prep methods by imputing the values into one field separated by commas (this has been set by the lab and cannot be changed). The problem is the report that...
The purpose of this query is to have a general query that can calculate the % compliance of different tests. I'm trying to get to the point where I can calculate the expression:
Compliance: ([TotalParams]-[NumberOutOfSpec])/[TotalParams]*100
To calculate the [TotalParams] field I'm using the...
My query that contains the fields
Result
LowerLimit
UpperLimit
I need a way to calculate the total number of Result values that fall outside of the upper and lower limits. What would be the best way to do this?
I tried to set column headings on a crosstab query so that I can display them on a report (since the column headings change depending on the OrderID). When I added the code in bold, it caused the query to not display any results in those columns
PIVOT Results.SampleNumber In ("Case 1","Case...
The comma was a typo. It looks like I got that error because I named the module with the same name as the function ("ConcatRelated") :o
Changing the query in the function to SELECT DISTINCT eliminated all the duplicates :D Thanks for the help!
Yes this is one of the ones I tried, but I could not get it to work. In the query I put
=ConcatRelated("OrderID", "Orders", )
But I keep getting the error
"Undefined function 'ConcatRelated' in expression."
The code I pasted into my module is
Public Function ConcatRelated(strField As...
I have a report that needs to take all of the values from a field concatenate them into a line and remove the duplicates. I have tried some VBA concat modules but haven't been successful in finding a solution.
I need this:
OrderID
1030
1031
1049
1053
1053
1054
1054
1054
1059
1059
1060
1060...
I'm sorry, I have read the 2 guides you posted and I'm still at a loss (I don't have much experience programming with VB) :confused:
Could you give me an example of what the code would look like?