Search results

Thanks but when i use it in a query it just gives me a list of records.

hi there can someone explian to me how the max function works!

Thanks Paul that really sounds like it could work! Is it all possible for you show some sample code on how I would do that. Regards Justin

Hi there Thanks for the post I really appreciate it. This is all on one table because it is reletive to each record. But say I added another table with an identifer how would that help me? Regards Justin

the problem is in your time and date field of your table you selected that the difult value be =now() which is the time and date so what is happening is when you say between 12:00 and 13:00 its not working because of the date side of it what I would suggest is that you change the time and date...

I used this code and it work so try it like this Private Sub Form_Load() If Text0.Value > "10:39:33 AM" And Text0.Value < "12:39:33 AM" Then Text2.Value = "early" End If End Sub

Hi there I have a problem that I just can't find a way to solve. This is an example of what my table looks like:(the differnt colors are for the differnt coloums) Transaction no item fig 1 fig 2 1 car1 100 2 car2 240 3 car3 160 4 car1 150 5...