Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report based on crosstab?

Status
Not open for further replies.

elgoober

IS-IT--Management
Oct 18, 2006
1
GB
I have a report that refers to a crosstab query - I can get results - the snag is - if I put criteria in the underlying query (not the crosstab) and run it - if I type say customer1 - results appear - but if I type say customer2 - an error message appears where it doesnt recognise the crosstab as a valid fieldname -(even though the initial qry ran thru fine)
Needless to say - doing my little ole head in

Any advice greatly app

Paul
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top