Hi all,
I am using MS SQL and I need help with creating a column were I can add a sequantial numbering of groups of records based on sequantial dates. The table structure is as follows
MemberID EnrollDate TermDate
001 01/01/2005 05/30/2005
001 07/01/2005 09/30/2005
001...
Hello everyone.
I desperately need help with this project, and I will appreciate any suggestions.
I have a Main form with a subform, which in turn has another subform with a tab control with other three forms in each tab. Each form corresponds to a separate table each. I set up this form to add...
Hello all,
In our community health center we are building a database that collects prenatal care data and delivery data. To collect the prenatal care data we have two tables one for women who received prenatal care in our clinic (TblPrenatal) and another one for women who came to us after...
Hello,
I am looking for help with a form that has a subform with a tab control. The main form has a subform with a multipage tab control, the first two pages of the tab control are based on one table wich I splited into two pages (this is linked to the main form based on Pk-Fk). There are three...
I have a Main form with a subform1 which has a nested subform2. The main form has two unbound combo boxes and a bound text box, these forms are linked and well synchronized and movement between controls from form to subforms was fine until I added a command button on the first subform to open...
Hello all,
I am working on the creation of this database that is taking me a long time because I am not very familiar with Access. Anyway, now the problem is the following: I have a Main form with a subform, which in turns has another subform. These forms are bound to three different tables that...
Hello all,
I am creating a database that stores data about patients participating in a health education program. For this purpose I have two tables, Table1 stores demographic and baseline information, with an auto number as the Primary Key and Table2 stores the first intervention done with the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.