Search results

I am using the Northwind Database example. I have a Product table with a product called Injection1, Injection2, etc In my order form i have a subform called sbforderdetails and another called sbfvitals. in the order details form there is a dropdown combo that has all the products . In the...

In my Patients table i have a field called PatientID (AUTONUMBER) as my primary key I hve another problem. Is this possible as i hve been trying for two days now. I hve tried a lot of ways but i cant get it to work right. I have a table called dependents. ID , PatientID,,Dependents,DOB,Age id...

I have a field in my table called SATS. This is then on my form as a control bound to the SATS field in my table. The application is for a surgery where the person doing vitals ( blood test and HPpressure testing) need to enter the redings. The norm is 96%RA80 tHE 96 never goes beyond 100...

i have created a form in access that has an autonumber for id and selects the first letter of the last name . I then concatenate the two to gime me example A2. the problem i have is that ineed to increment all the A as A1,A2 and the all the B as B1,B2 etc. So if a lastname is Denver it take D4...