Recent content by JRPMD

Thanks for your answer. The tables have an Id wich is an autonumeric field . And I create a relationship between the tables. It works properly in subforms and I can see records 1, 2 o 3 using this code , but not if there are subforms or subreports in a report , in wich they show the first record...

Hello , I have three forms , based in the same table , in order to show the first , second and third records. The following code in each form works properly: Private Sub Form_Open(Cancel As Integer) DoCmd.OpenForm "Form 1", acNormal DoCmd.GoToRecord acDataForm, "Form 1", acGoTo, 1 End Sub...

Alright! I learned a lot ; and also about the interesting nz function!

Thank you very much for your excellent database and querys . That's exactly what I need. I think this matter is solved. Thanks again!

Yes , I can use DCount , but before count I need to retrieve the records in wich the admission-discharge interval comprises the selected day.

Thank you Arnelgp for your excellent query and module , I think is useful to know how many admission there are in time period. But also I want to know how many people were present not in period but in one selected day ( in order to calculate resources spent in that day, personnel required etc).

Thank you very much, I will try.

Yes , the people that were present at a single day , i.e 6/6/19 are : Id 1,3 ,5 and 6.

Hi , I have not a code ; I'trying to make a query with an expression : between [admission date] and [discharge date].

I prefer a code. I don't know wich is the appropriate syntax ; I'm not to skilled in programming codes , so don't tryied it and ask for some help.

The tables is Ingreso.

Hello, I have table in a database with two date fields , admission and discharge date to a clinic . I can count the days between this two dates in a query . Now I want to know how many people is present at a single day (x day). I think it is possible making an expresion like : x day ...

Thank you very much! It works

Hello , I have a query based in a table and in another query. They are related by an index field of the table and the same field in a query wich is not a key field. The field 'Nro de Orden' in the table is a key field and there are 13 records. The query shows 23 records. I grouped it by 'Nro...

Thank you very much!