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...