Hyperlink field not working in crosstab query

Question

0

hi all,
i have created a crosstab query and one of the row heading contains a hyperlink field.
my problem is that the field is not working,
and on top of that it gives corrupted values too.

pls help
thanks

microsoft-access

2

Contributors

2

Replies

3

Views

7 Years

Discussion Span

7 Years Ago

Last Post by isumasama

This Question has been Answered

1

hi all,
i have created a crosstab query and one of the row heading contains a hyperlink field.
my problem is that the field is not working,
and on top of that it gives corrupted values too.

pls help
thanks

I don't believe you can use that directly in a crosstab. Create your crosstab query without that field and then create a select query which joins the crosstab with the hyperlink field in it.

microsoft-access

isumasama · Answer 1 · 2011-04-19T07:04:56+00:00

wow, u're right. it works now, thanks