Crosstab Query - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Crosstab Query

Erol Ver

5 years ago

Hi Richard,
I've been designing a DB for my workplace, where I need to compare salaries by property, year and department - it requires a crosstab query, which I have managed to create one but failing on how to filter the output - any ideas? If necessary I can post a sample of the DB also

	Adam Schwanz @Reply 5 years ago
What do you mean by filter the output? Like by a date/location or the way the data looks? If you could upload an image of what's happening using Snip & Sketch and then tell us how it's supposed to look?

	Richard Rost @Reply 5 years ago
I responded to you earlier on FB or wherever you messaged me. What I would do is filter the results FIRST in a normal query. Then use that query to make your crosstab query. Don't try to put criteria in the crosstab.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View