I have a pivottable built off a query that is used to populate the listboxes, 1 for location 1 for category.
Those fields are included in the query to generate the sums based on the age of each record. ie, <15, 15-20 and >20 days old.
After selections made in listboxes, I am able to generate a detail page that allows users to be able to review the individual records. They would like to have the pivot table...
FrankB63
Last Activity: Jun 24 '10, 07:42 PM
Joined: Jun 15 '10
Location:
-
Update subform Pivot table off Listbox selection
-
Issue was resolved by assigning all fields in Rawload tables to text, no index, Allow zero length and not required. Not sure which one of the options did the trick but after making those changes all records loaded. -
transferspreadsheet not capturing all records in worksheet
My db needs to load xls files that are dropped into a folder by Peoplesoft. The first row contains record count information and the second row contains field headers.
My code is finding the correct file to load, processing the load into a tempory table, then moving and adding two new fields,one today's date, another a calculated filed based on another field to ease other queries.
Problem is that the code only...
No activity results to display
Leave a comment: