Recent content by SunTsu

Ok, let's try with a pivot table. Basically, I have a table ("tType") that has just IDs and names of five meals: breakfast, lunch, etc. And I have a query that contains all the summary for those meals for different dates such total of calories. When I run the query for the date where there are...

Here is the sample query (final query will have all num_fields with nz function to convert null values to '0' SELECT t1.Date_field, t0.textfiel, t1.Num_field1, t1.Num_field2, t1.Num_field3, t1.Num_field4, t1.Num_field5, t1.Num_field6, t1.Num_field7, t1.Num_field8, t1.Num_field9, t1.Num_field10...

I am using MS Access 2007. I have a base query (q1) that has 19 columns: date, Row_name (with 5 possible values) and 17 numerical columns. You are right, at the moment it doesn't matter that it's going to be used in subform. Basically, a query that provides a record set with five rows and 18...

Hi experts! I need to create a subform based on a following recordset: date_field, text_field, numerical_fields1-17. text-field have 5 specific values and I need the final record set to consist of 5 rows (based on text_field) followed by 17 columns of numerical fields where date_field is used...