Search results

Attached is the sample database for your reference. You need to open the form and enter the condition (just the number without any operator) and click the command button. Let me know if that helps. Murli

I dont think so. Not sure why its not picking up on yours.

Here you go!

Hi, You can create a query to get the total hours group by company and with a criteria >[forms]![formname]![textboxname] and call this query using a command button on your form after entering the data in the text box. The query will display the records based on the number entered in the text...

You can use an update query to change the dates.

The expression which you are trying is correct and works fine on my system. Did you check if the formats is set to Date in your tables and the unbound fields?

You can use the Group By function in your query on the field department and build an expression basic hours + overtime. A sample database is attached for your reference. Murli

Hi Catherine, I have attached a sample file for your reference. Murli

Try this: DELETE Table1.* FROM Table1 WHERE (((Table1.Name) In (select Name from Table2)));

Try this: Syntax: Select Table1.Field1, Table1.Field2, Table1.Field3 from Table1 LEFT JOIN Table2 ON (Table1.Field1 = Table2.Field1) And (Table1.Field2 = Table2.Field2) WHERE (((Table2.Field1) is Null)) Union Select Table2.Field1, Table2.Field2, Table2.Field3 from Table1 RIGHT JOIN Table2 ON...

Enter the following in the criteria section of username field in your query: =[forms]![formname]![textboxname]

But the crosstab query needs a minimum of three fields. Wat do you say?

Hi, The unmatched query you used on the field last name will not work as there are multiple rows with the same last name. Inorder to make the query run the entire record has to be compared between the two tables and not just the last name. I have made the corrections in the attached file. Murli