Search results

Old thread! I had the same issue and it relates to concatenation with a calculated field in sharepoint. I deleted the field in SP as I can do the concatenation in access and bingo, no issues...

Thanks Steve, I found this article on crosstab query parameters and the second option worked for me - Specify column headings. allenbrowne.com/ser-67.html It works great now as a prototype but if I want to develop it further I will need to learn how to make the column headings dynamic...

Thanks Steve, That worked for the most part. I was able to construct 6 tabs that are filtered based on 2 combo boxes which is fantastic. 1 tab did not however work and the difference here is that this tab is based on a crosstab query set in a datasheet. Have you come across this before and is...

Hi Steve, Thanks for your reply. In essence I have a bunch of small data sets that relate to the same topic and are continuos forms or datasheets, ie differing number of records. I want to see the datasets based on a multiple of two categories, let's say area and type. I had hoped to put my...

Hi All, I have not been here in a while. Its good to be back :) I couple of years back I would have been able to answer this but its amazing how quickly one forgets... I have a Navigation form 'MainForm' with a Combo20 drop down. Implanted in the form is a NavigationSubForm with a data set...