Search results
-
O
Joining union queries to ultimately chart data
I still haven't managed to bust this problem. Any suggestions please!? Many thanks!- olive
- Post #4
- Forum: SQL Server
-
O
Joining union queries to ultimately chart data
My sincere appologies Whatever my thoughts, they were clearly more confusing than not :( I would still really appreciate your advice on this topic and promise to stop multiple threads in the future- olive
- Post #3
- Forum: SQL Server
-
O
Joining union queries to ultimately chart data
Here is my dilema Note I'm new to access I want to create a chart, Wheel diameter vs number of wheels with that diameter. The chart takes in three sources of information: Wheel Diameter on unit one, Wheel Diameter on Unit 2 and the combined Wheel Diameter of both units with the diameter...- olive
- Thread
- Replies: 4
- Forum: SQL Server
-
O
union queries
Hey thanks, The source isn't actaully a table, it's a query itself. The SQL code is: SELECT (SUM([3CDiaLess530])) AS TableDia3car FROM qryDiameterAvg3car UNION ALL SELECT (SUM([3CDia530to540])) FROM qryDiameterAvg3car UNION ALL SELECT (SUM([3CDia540to550])) FROM qryDiameterAvg3car UNION ALL...- olive
- Post #3
- Forum: SQL Server
-
O
union queries
Hi I am generatin a union query based on wheel diameters previously in seperate fields. However when I create the union query the data is automatically sorted in ascending order and deleting records that contain repeated numbers. For example, I want the data from the different fields to be...- olive
- Thread
- Replies: 6
- Forum: SQL Server
-
O
Access newbie needs help! with charts and data order
cheers that worked great. I have another problem now. The union query is automatically sorting the data in ascending order and deleting records that contain repeated numbers. For example, I want the data from the different fields to be entered in this order: 6 6 4 3 3 7 19 28 but the... -
O
Access newbie needs help! with charts and data order
cheers that worked great. I have another problem now. The union query is automatically sorting the data in ascending order and deleting records that contain repeated numbers. How do I turn off both these properties? Many thanks -
O
Combined bar and line graph
Hi all Is it possible to graph information in a combined graph represented as both line and bar charts? (As you can in excel?) If so any hints on how to get started? Cheers! -
O
Access newbie needs help! with charts and data order
Hi, okay completely new to access. I'm trying to create a chart based on a query with 1 record 8 fields. I can not figure out a way to rearrange the data into two fields 8 records. The background is I have a hundred units, each with 8 wheels. I have a table with the following fields. -Unit part...