Search results

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!

Hello theDBguy , the tables are related in the original DB by the field [Nro de Orden]. I made a reduced version , with only a few objects ,wich is under 2MB in order to post it. My main interest was the code : "Private Sub Form_Open(Cancel As Integer) DoCmd.GoToRecord , , acGoTo, 1 End...

Hi, theDBguy , sorry I was trying to reduce my DB (50M) and creat a new DB with a few tables , forms and reports related to the question I made. Now the code seems to work properly and retrieve the first , second and third records of a table (altough sometimes there is an error). The code...

Alright , I have to print a daily report in A4 sheet and have very little space because of many reports and subreports in that sheet . Now I have a form ( or report) with fields like , Name , Id , date of birth , gender , Admission diagnosis, etc. And then another table and form with a field...

Thank you very much!

Hello , I have a form , Form1 , in wich I can see the second record of a query. I wrote this code : DoCmd.GoToRecord , , acGoTo, 2 at the OnOpen event and it works properly showing the second record of the query with an Autonumber field. Now I made a new form , Form2 , from a different...