Search results

OK, lets start over from the top by reexamining you first post. 1. You said the output should be Rec1,Rec2 & Rec4. But your output should really be Rec2 & Rec4, simply because Rec1 does not have a record before it as a reference point to see if 13:00 is between it. 2. Your start time of Rec4...

JET which is the database engine that access uses is not smart enough at times. These types of queries do not show in design view. Therefore ,you have to handle all your edits in SQL View. I don't understand you last question.? Can you please explain again. dallr

What do you mean it gangs? Is it taking to long to run? Have you tested it with a small amount of records first? Dallr

Try: SELECT T1.* FROM YourTable T1 INNER JOIN (SELECT Max([Date]) As MaxDate, Item FROM YourTable GROUP BY Item) T2. ON (T1.Item = T2.Item AND T1.Date = T2.MaxDate) PS: Please note that the word date is a reserved word in Access Dane

Alex, is this question linked to this one in many, way to me there are similar. And if that is the case then why have two threads running at the same time. Or two threads saying different things but trying to achieve the same output...

Both of the aforementioned techniques can work but they are very static in nature. Meaning end users cannot dynamically change the range values except they get access to your module and SQL, and of course we don’t want user to be manipulating our SQL or Modules. This brings us to the 3rd...

Does your table have a primary key. If it does you can use the following SQL. I am also attached a sample db. SELECT YT1.* FROM (SELECT * , (SELECT count(*) FROM Yourtable Y WHERE Y.ID<=Yourtable.ID) AS DerivedAuto FROM YourTable) YT1 LEFT JOIN (SELECT * ...

I would just say that you show us your listing of tables and state what results you want to have returned. In that way someone can write a query and explain how it is working. dallr

Mvorous Although, Wiklendt might come off a bit strong I am in agreement with what she is pushing for. I to cannot see the need for what you are asking, hence my comments. But seeing you are adamant of what you want, what else can we do :confused: Dallr

Glad to help! Dallr

My last post was for peekaboo and not your Mvorous. Mvorous It is my error, I misunderstood your question so discredit my first post. My question to you now is. Please explain in detail what it is you are trying to do. .....expand on the following because I am not understanding this fully.

Why do you want the autonumber to match the number on the record selectors? Autonumbers are really for internal database use and they should not be seen or used by the end user as a general rule. Dallr

So much things to say here..... 1. You do not need to use DAO here to open a recordset and pass the value from your query (currentLoggedOnQry). I can fix your initial code but, as I said doing this is unnecessary. 2. You can simply use. Dim strSQL As String strSQL = "INSERT INTO UserLogTbl...

There are a number of ways to do this. You can simply place the Dcount function in the following events on your continuous form. Then let the value returned by the Dcount be passed to your unbound form control (YourFormControl). The table or query used in the dcount should be the same one that...

Take off compact on close. Go to TOOLS --> OPTIONS --->GENERAL (tab). Uncheck "compact on close".

Thanks, I am out! Dallr

Cool!! Thanks Paul And what is the Green dot under the total post count. Last question i promise,

Leigh I guess I have to or possibly "compact and repair" the old brain to get thing back in order. LOL Brent I believe the OP noticed that because of the information in the sample results they posted later down in this same thread. Nevertheless, I am glad you noted it because persons who are...

I am new around here and trying to figure things out.I just noticed that some names have a green dot by the side of the members name and other's don't. Why is this? Is it a rating level for the post or something.

Leigh I realized that I forgot the Order By Clause (oops). But I was waiting to address this in my reply. But for the life of me i could not remember how to remove the ties I know i did it before. Thanks for ticking the ole brain!! Dane