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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: omondragon
- Order by date
-
Data Labels with Values in crosstab query or report
Is there a way to include the data label as part of data. For example I have the following data set: I would like to see a table that has Price as a Row Heading, Quarter as a Column Heading and both the Product and Qty in the detail (so that they are grouped into as few rows as possible at...- omondragon
- Thread
- Replies: 6
- Forum: Microsoft: Access Other topics
-
Determine a value associated with a range
Thanks V...that is exactly what i was looking for. One other question, how does the statement change if I am looking at dates. i am now trying to assign a fiscal quarter based on a transaction date (e.g. if a transaction occurred on Feb 1st then it would assign it a Q1 label...i do have a...- omondragon
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Determine a value associated with a range
I have a table that shows a range and a value associated with that range...see example below. I have another data source that has values. Is there any easy way to determine if my values fall within one of the low and high values and determine which label it is (e.g. if my datasource has a...- omondragon
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
