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!

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

Limit # of rows in crosstab query

Status
Not open for further replies.
jvanderw

jvanderw

Technical User
Aug 13, 2003
28
0
0
US
Hey all! Here is my problem -
I have a crosstab query that is grouping data by week ending dates (Fridays) for a year's worth of dates. I then export the queries to excel and have some graphs set up to display the data. My problem is that sometimes there are 53 week ending dates in a year. How can I make a crosstab query show only the last 52 rows?
Thanks,
Josh
 
Sort by date Sort by votes
Can you use "Top 52" in your underlying SELECT statement to only return the Top 52 dates? Search Access JET SQL help for the TOP reserved word...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
123
JimStrand
JimStrand
btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
168
dhookom
dhookom
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
168
combo
combo
serino
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
296
serino
serino
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
176
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top