UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> crosstab date range    
 
   
BridgeBulider69
post Jul 14 2005, 02:34 PM
Post #1

UtterAccess Member
Posts: 44
I have been looking for a solution to this but have not gotten very far, can anyone point me in the right
direction. I have a crosstab query w/ part category for the row heading, Part Type for the column, and $ Expensed for
the value. I need user input to determine the from and to criteria on which the the data is displayed in the crosstab. The crosstab query will take an entry such as #1/1/2005# as a valid criteria but when referencing a date range from a user entry form I get an error. Anything would be greatly appreciated.

Thank You All

Mark
Go to the top of the page
 
+
Larry Larsen
post Jul 14 2005, 03:37 PM
Post #2

UA Editor + Utterly Certified
Posts: 22,726
From: Melton Mowbray,Leicestershire (U.K)
Hi Mark
Check out:
Error When Running Crosstab Query with a Parameter.
(IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif)
Go to the top of the page
 
+
« Next Oldest · Access Reports · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 02:00 PM