1

Topic: As lines in request

It is kind nights. Help, please - it is impossible in request  lines. A DB I apply. Also I apply a type of request to what would like it to receive. Thankful in advance. Yury

2

Re: As lines in request

Now I will put a DB

3

Re: As lines in request

on the Patient, DataOperatsii
Also deduce sum (_)

4

Re: As lines in request

SELECT the Patient. , Operation. , Sum (Infusion. _)
FROM Patient INNER JOIN (
(IstorijaBolezni INNER JOIN Operation ON of IstorijaBolezni.  = Operation. )
INNER JOIN (Infusion INNER JOIN of InfuzijaSpisok ON Infusion.  = InfuzijaSpisok. )
ON Operation.  = Infusion. )
ON the Patient.  = IstorijaBolezni. The patient
GROUP BY the Patient. , Operation. ;

5

Re: As lines in request

982183, thanks big for a variant! I apologize, and it is possible a plotter? Well or a macro. I am simple in programming is not strong smile With . Yury

6

Re: As lines in request

Pass in mode SQL and interpose the text

7

Re: As lines in request

982183, well or it is possible to ask to register it directly in request in my example. Well I am not strong in programming. With . Yury

8

Re: As lines in request

982183, thanks, I will try