Search results

i think i don t undesratnd well what you are suggesting me For now i have changed all the MASCHERE with FORMS in the FORM RICERCHE, so you shiuld be able to run it you don t need to run any queries as they serve for the report, they all are for counting the records, they are ok I deleted all...

no there is still a problem the date query works but not the other filters, don t work anymore any of them

i correct i have set again the select distinct which i deleted to restore and now no more duplicates so most porbably depended on the + instead of and? looks like i don t get properly this and naming - the above references the id control on the form anyway really thanks, ,now the query for...

thanks i have changed the operator but donn t seems related to the showing duplicate record issue

tied it..no change

arhg..i have just find out that after inserting the criteria search for datem the other criteria in the RICERCHE (id, cognome, sesso, titolo di studio,occupazione, sostanza primaria, sostanza secondaria) don t work anymore i attach the db as it was until today you open the ricerche ant...

anyway the 8 it does exists, i did not check properly as i said the id used as primary key is not shown, the numeber you see is for operator use,and wqill be alphanumeric the 222 has got a primary key id 8 and this 8 become the id for the table date_trattamenti

in ricerche set start date at 1/1/2017 and final date today you ll see that the 222 come up twice but it is a duplicate if you open th + you ll see the same datas for the fiorst 222 and the second 222 beware that 222 is not the id used as primari key. that 222 is just for anagrapgic use, hust...

ok the ID8 and subsequent datas where just example, are not in the db Perhaps i don t undesrtand clearly what are you suggesting, the problem is not in the seacrh criteria but in the fact that if a patient come more than once in the period a choose he will be showed up more than one time, while...

in all the other queries, that are the main pourpouses of the db, this methd work, and i can get the final report as desidered Now i though i could use the date filtering in RICERCHE also and the poroblem has come up

i know i need it like this this table have has record 3 parameters Dateform date to and treatment The id of this table is linked to the id Of Anagrafica, whic is a person If a person have the ANAGRAFICA ID= 4 then the date_trattamenti have this number 4 for each time he got treatment for...

Hello in my db i have a form called RICERCHE (means search) wich i use to filter data according certain parameter There is one parameter,the search within dates interval that "SPOIL" treturned record. They are shown more than once. As soon as i insert the table needed for the search...

ok it works i was using , instead ; in the colum heading Great I really thank you! :)

hello Thanks a lot...Great! I can eventually do what i need Please tell me hot to replicate onmy original db(i have posted a moidifed one for make things easier I put the report in the main report, in the BODY part I have set the column name in all the queries But i have receive error in my...

Hello i have in my db 7 reports made from 7 crosstabs queires I am trying to use this path to gather the report Put in the foot of 1 report another report But i receive an error and the 2 report is blank I attach the db if you start the report ETA, at the foot of it there is the report...