Agassi
-
Help with SELECT query needed!
Hello, guys!this task is too much for me, and i ask your help please!! I got 3 tables that are joined as 1:N as shown. Patients Visits Treatments As you can see, every patient can have various visits,…
-
Autonumber a filtered list
Hello!I got an table named Citas. I need to select a date range from it, sort the resulting list by date, and then number it starting from some number. I used to use the solution provided here on the…
-
How filter records with same field value
Hello! I got tables Treatments and Patients, with reference N:1 from Treatments to Patients. Because each patient can have the same treatment various times through time,…
-
date = Today () returns nothing. (
Hello! I got a date field. I created a formula column in that table to filter records with the date of today with a simple formula: date = Today () But it returns nothing.…
-
How select records from related table not older then 3 months
Hello! Actually the subject says it all. I searched for a similiar question here, but did not find... In table Treatments i need to have an average cost of a product i bought in a period (lets say 3…