1

Topic: Very difficult report, at least double request

I need to create the report in which fixed amount of columns
Breakfast the Dinner a mid-morning snack
Dish 1, dish 2..... 5, 6.............
1 2
Anything more cleverly than to create  the table and to bring there program values I did not invent
Here at me it is a lot of questions
1. How to sort out program all columns of cross-tab query, them after all it is not known how many
2. To import the data to the table or  running on columns, I do not know as to search for value of a line on value
3. Or  setting the text of update query and to fulfill it, it generally put out the light, I am afraid I will be tangled

2

Re: Very difficult report, at least double request

antipod;
Gaps were erased
The type report
__________......
Dish 1, dish 2................... 5, 6.............
1 2

3

Re: Very difficult report, at least double request

antipod wrote:

gaps were erased

Use a tag Table (CSV), values divide commas:
Breakfast, Dinner, Mid-morning snack
Dish 1; a dish 2, Bljudo5; 6;
1 2;

antipod wrote:

I need to create the report

And we are offered to guess, from what initial data, so?

4

Re: Very difficult report, at least double request

And how differently to train ?

5

Re: Very difficult report, at least double request

antipod;
Attempt to guess
[CSV = \] a breakfast \zavtrak_ \breakfast __\ ___\ a...... \mid-morning snack
Dish 1, \a dish 2. \\Bljudo5, \\6.
1 \produkt2 \\\\
Product \product \\\\
Product \product \\\\

6

Re: Very difficult report, at least double request

THE PENSIONER;
Yes you are right
Problem in that that at cross-tab query two columns from the initial table as titles should be
The initial table
_, a dish, date
Composition of products in the additional reference manual

7

Re: Very difficult report, at least double request

antipod;
For example the such
Probably
1 Date-tipkormlenija-dish;
Date, feeding type, dish
01/05/2017, a breakfast, a dish 1
,,2
,,3
,Dinner, dish 11
,,Dish 12
,,Dish 1
,Mid-morning snack, dish 21
,,Dish 2
02/05/2017, a breakfast, a dish 4
,,2
,,6
,Dinner, dish 11
,,Dish 12
,,Dish 1
,Mid-morning snack, dish 21
,,Dish 2
03/05/2017, a breakfast, a dish 1
,Table 2 dishes-products - a bookmark;
The code, dish, product,
1, porridge semolina, milk, 10
,,Decoy, 50
,,Salt, 10
,,Oil, 10
2, cocoa, a cocoa powder, 10
,,Milk, 10
,,Sugar, 10
,....;
Also it is necessary to receive, and number of columns and lines a miscellaneous every day
Breakfast, 01/05/2017, a dinner, ;
1, 2, 3, 11, 12, 3, 14, 21, 2
Porridge semolina, cocoa, a white loaf, soup fish, meatballs, a garnish, tea with a lemon, donuts, cocoa
Milk, cocoa powder, a potato, rumpled, macaroni, tea, a flour, a cocoa powder
,,,,,,,,
Salt, sugar, , a lemon, oil, sugar
Oil, salt;
,,,,,,,;
Breakfast, 02/05/2017, a dinner, ;
Porridge millet, milk, bread, soup dairy;
,,,,,,,;

8

Re: Very difficult report, at least double request

antipod;
Look it. 1 (in a browse mode) - can than helps

9

Re: Very difficult report, at least double request

sdku;
11, 1, 2, 3
Potato, 0,1,5
Onions, 5,0,1
Flour, 1,0,0

10

Re: Very difficult report, at least double request

antipod;
It turned out normal to create the table, and all it for a breakfast a dinner and a supper, a mid-morning snack still. Fornication the different

11

Re: Very difficult report, at least double request

sdku;
Did not understand as an example to use, the report all fields free, shows the pure form.
Basically I can create 4 cross-tab queries for a breakfast a dinner and a supper, them here to unite in one printing form

12

Re: Very difficult report, at least double request

antipod;
Read that is written in brackets - a browse mode
Right  on the report and to select "print preview", count columns and close
Then add in the form "arrived" record: mark-car, proizv.-kitaj, an amount-any, save record
Open the report and count columns

13

Re: Very difficult report, at least double request

sdku;
Not feeblly, it precisely to be useful, only now there is a question how to collect one request from 4 the cross.
Can prompt as in  to sort out all columns without knowing their amount?

14

Re: Very difficult report, at least double request

antipod;
Oh it seems saw in the report.  I will try

15

Re: Very difficult report, at least double request

antipod;
It would be desirable to see your circuit and look this-can this that that you want (not up to the end)