fraser_lindsay
Access wannabe
- Local time
- Today, 13:55
- Joined
- Sep 7, 2005
- Messages
- 218
I have a table linked to another table in a one to many relationship.
I am trying to get a query to work out some statistics by group the many records on the right table. I can use the group by function and the built in functions such as min, max etc.
However, I need to do slightly more complex expressions to produce statistics that I require.
To complicate matters, my tables are built into another query (X) which calculates some expressions. In the query I am trying to set up I am trying to maniputae numbers from query X.
I can't get this to work using the build expression function, I keep getting errors. Is this because I can't query a query or can't query previously calculated fields?
I hope this makes sense.
I am trying to get a query to work out some statistics by group the many records on the right table. I can use the group by function and the built in functions such as min, max etc.
However, I need to do slightly more complex expressions to produce statistics that I require.
To complicate matters, my tables are built into another query (X) which calculates some expressions. In the query I am trying to set up I am trying to maniputae numbers from query X.
I can't get this to work using the build expression function, I keep getting errors. Is this because I can't query a query or can't query previously calculated fields?
I hope this makes sense.
