Search results

Heading in a different direction now. Mike i noticed you said this What updates are you talking about here? Since the data is stored in the server why not use a stored procedure executed from Access to hand this? Dallr

Thats one of the downsides of the Top predicate in Access. Dallr

Welll that is extremely risky!! Secondly, are you sure the registry value will note if it is a view. Remember the link does not hold any details. dallr

Leigh gave you a good solution. What I am providing as an alternative solution which works more in reverse. Step 1 Let your DBA create a view within your sql server which lists all the views within your specified database. example. use <YourDatabaseName> go CREATE VIEW vw_sysviews AS SELECT...

I am not sure what you mean by League table format. But the following should give you the top 12 scores per member along with the total for that member. I used the same fields you used. I noticed you mentioned something about a number of weeks. You will have to explain more of this for me to...

The code I provided should handle it without a problem. I was just asking so that we covered all possible scenarios of how the data might be stored. Glad to assist. I am out! Dallr

Maybe it me who did not phrase the question correctly. What I was asking is, what happens when two of the same objects have records in sequence whereby the end time of one record is within 10 minutes of the next record. Example Object1 10:00 10:23 Object1 11:41 13:57 Object2 12:07 12:45...

OK, once you are happy. Dallr

I can provide another solution which uses the same fields you provided but without the autonumber primary key (ObjectID). However, it depends on the last question I asked. dallr

Question: What suppose to happen when two objects are in succession and have times within 10 minutes? Dallr

I would create a primary key (automnumber) within your table. I called this autonumber ObjectID in the following sql. I called my base table Yourtable. So in the following SQL wherever you see the table "yourtable" replace it with the name of yours. I have also attached a sample db. SELECT...

Allan It is good to be here, I would definitely pop in from time to time and lend a hand. Leigh "the plural of Borg is Borg".....You see why i need assimilating LOL Dallr

Brent like you and Leigh planned an attack to simultaneously take over this forum and assimilate us.. http://www.access-programmers.co.uk/forums/showthread.php?p=718181#post718181 You Borg's you!! :D PS: Or is it you just like to follow me around. dallr

This should do the trick, the previous link does not work in 2007 http://www.utteraccess.com/forums/showflat.php?Cat=&Board=48&Number=1658279&page=0&view=expanded&sb=5&o=31&fpart=1

"MVP Insurance", I like that one Bob!!

Leigh like you are popping up all over the place now. LOL Dane a.k.a dallr

I hear you!, I only recently joined and just pop in and out when I have nothing to do. I wouldn't be spending to much time there though. dane

Hey Chris whats up? Didn't realize that you were at this neck of the woods? Dane aka. Dallr

I appreicate your feedback and comments regarding the solution you provided. However, you are justifying the use of your solution on how easy it is to setup and reuse. While that is might be a valid point in another context, it is not advantageous in this case. When dealing with queries one...

I ment no disrespect when I say that it would run faster than VBA. (i.e the solution in the link). I was just stating a well known fact. It took me less than 5 minutes to create the query that i suggested as a possible solution. I said that to say, the more an indiviudal understands a set...