Search results

I have created a crosstab query that shows file types as the column headings and names as the rows. The aggregate function sums the files per type for each name. I know how to fix the column order for the file types using the PIVOT statement shown below: ..."PIVOT...

Hi, I am having trouble updating the data in a subform after the user selects data from a control. This is the design of the form... I have a set of controls (ListBox, CheckBoxes, and Date Enters). Below these controls is a subform that has a datasheet that displays data using a crosstab...