Search results

You have to use group by But you can get the appropriate results by grouping properly

But my question was where are you putting the criterea statement I assumed that you have a main form and a sub form from where the query will get data in that case my statement should work

I wrote this using the form names you told where are you using this statement

I wrote this using the form names you told where are you using this statement

use this criterea Between [Forms]![frmMainForm]![frmreports].[form]![txtdatefrom] And [Forms]![frmMainForm]![frmreports].[form]![txtdateto]

Have you seen orders form in Northwind Sample It shows a master child relationship between orders and arder details tables using sub form

You have to maintain record for each location of patient it could be maintained very easily through master child using forms and sub forms

You have to modify your query or apply a filter to report through form. I have used the query method modified sample is attached

Use this sql in the row source of combo SELECT ITEMLIST.Ttem_Name FROM ITEMLIST union select '<All>' FROM ITEMLIST order by Ttem_Name;

use this after inserting value in table me.mycombo.requery

try to insert using field names

code for message box is as below msgbox("Enter your message here")

Try this "Insert into tblCountryState values (" & Country.Value & ", " & strValue & ")"

use before update event of form and check there whether the value is provided for the field or not

you can use mytext1=myuserid on some event of form

I think you have been told the solution already You have to use main table for patient information and child table for locations enter date transferred to and transferred from room for each record except for the last location where transferred from will be null from which you can show the...

Check the attached file

On the after update event of text box enter this txt1=ucase(txt1) replace txt1 with your text field name

You can set this in the default value property of control

You can use United Kingdom