Recent content by dzepeda

Try something like: SELECT Format(Max([Time])-Min([Time]),"hh:nn") AS Elapsed, Format([Time],"dd-mm-yyyy") AS Day, YourTable.StaffMmember FROM YourTable GROUP BY Format([Time],"dd-mm-yyyy"), YourTable.StaffMmember; This must return the elapsed time between the first and the last hour of...

This is not a criteria, you must show the totals row (menu View ->Totals), under your field will appear Group By , then select Max as Total (you also can select min, averange, count, etc) Greetings from Chile

flugh: Like I say previously the logic of the sentence is not the problem. I put the generated sentence manually in the query and It works exactly as I want, the problem is to make this through a parameter(The sentence is generated automatically)

OhioSteve Thanks for the tip, but probably my bad english cause I can express my problem appropriately: The criteria is a combination of values of one field of one table(And - Or combination) and not only a fixed value. In code: 'StrQuery is a Public Variable StrQuery="[Table].Field1...

The idea is select only the recors where Field1 is diferent of a serie of values: i.e. Field1 Field2 ------------------------------ a ! 1 b ! 2 a ! 3 d ! 4 h ! 10 1) Select only the fields <>&quot;a&quot...

I have a string with the criteria in a select query (source of another) something like &quot;[Table].Field1 <> 'X' and [Table].Field2 <> 'XX'&quot;. I'm not able to make the query through code, 'cos It's a part of a second query, and that part of another... I try to make a function who pass the...

Thanks Garridon, very helpful. Honestly I don't watched at the menu bar and I've tried the property tab several times with no result.

In some samples I saw that. How can I do this? Thanks

You can make a table (PassTbl) with only a field (Ctrl), type Yes/No, now create only one record with value yes. Create a query an set relationship between the Complete field and Ctrl field of PassTbl. That must show you only the record with Complete=True Greetings from Chile

Try putting this in the on change event procedure of your text box: Me![MyCheck] = (Len(MyText.Text) > 0) Where MyCheck is your Checkbox Name an MyText is the textbox you want to link.

See thread702-597199

Andyukcy: The open argument field is a string, you can pass the value to the second form join the three fields in one. The second option is declaring three Public Variable and set the value you want in that before open the new form.

I suggest modify your form and replace the check boxes for Option Button(even you can make that look like checkbox) The easiest way is make a new frame with the wizard enable, then enter the values Monday..Sunday an select the aspect. Also you don't need to validate if the user has selected...

This code will make the replacement: [code] Sub ReplaceField() Dim dbs As Database Dim rst As Recordset Dim Po_Previo As Integer Set dbs = CurrentDb Set rst = dbs.OpenRecordset(&quot;SELECT * FROM [Table]&quot;) With rst .MoveLast .MoveFirst...

I'm happy to help you and thanks for the star, anyway what was the problem...?