Search results

Ok, I got it working quite well with Max(), the only time i'll get a wrong status will be if a status is downgraded in the same day it was upgraded. Not perfect but it'll do, maybe I'll change it to take time data as well. Thank you for this quick answer. ...that said, I would really like to...

Oh, I didn't think of using Max(). I'll try this. As for the dates in the same day, I have a lot of those, but doesn't the field still contain the time data even if it doesn't display it? I can't really do Max(statusID) because sometimes stuff is in testing phase (status 3) and goes back to wip...

Hello, I'm trying to use the last() function in my queries, but its behaviour transcends everything I am able to fathom. Please advise. Assume two tables. ------------- ------------- RStatusList Status ------------- -------------...

It is opening easily, in another excel instance than the busy one.

Hello, I'm experimenting with unbound object frames to embed an excel sheet in Access. So far it worked pretty well but I noticed an issue: If I have an excel application already open and busy, and then open my form, access freeze completely and won't do anything until excel stops being busy...

No, on the contrary, my fields are limited in size (ie I set some text field at 20 chars because I don't need more) when his are 255 chars etc No memo or OLE or images or anything weird.

Yes to both. I ran them together on my computer. Maybe I should have ran only 1 at a time but Access doesnt seem to use much of my cpu/ram if any at all, honestly.

He returns about 15 fields and I return 30, but even reducing this to 1 field only, it doesn't seem to go faster. As for the other database, it's just using my table through ODBC link, but I made my query directly in the file that has the table in it.

Yes, indexes on the WHERE parameter in each tables, because I indexed it in his table. Time measured is from clicking "execute" to getting the number of returned records in the little box at the bottom. I didnt measure it accurately because the difference in time is so huge, when his table...

Hello, An intern joined for a few month, a few months ago, and developped an Access database. He was in comp sci school but having worked with him a bit, he was not very good at anything computer related, especially not programming and SQL. Anyways, I had too much work and let him do his thing...

No but I know I should! :D :banghead:

Well, I seem to have wasted everyone's time and especially my own. I made a typo within my function and tried to access "sltcn" instead of "slctn"... the selection was passing through since the start. Sorry guys.

Hello everyone. Technically this is on Excel VBA since I open Excel from Access and work with it, but I don't think it matters since the problem here is clearly the passing into my function by ref. I don't get my issue at all, and I'm even pretty sure it worked just fine until yesterday and I...

Yes yes, [per] is the parameter passed in the final query and in all the subqueries. In the end, my query looks like that: (i can't post links apparently i'm too new so just append it to http) i58.tinypic.com/141p0yv.png in sql: SELECT Data.ClientID, Data.SorgID, Data.DivID, Data.BrandID...

How else would you do it? My users type 201401 and I have a dozen queries running on it with different variation. Some take the full year, other the month, other the month of last year, etc. And this one is the quarter one.

Putting everything in one expression is too tricky because for example 201401 will become 201400 + (01-4) so 201400+(-3) = 201397 ... Anyway, I think the OR statement will do the trick. I tried on a couple and it worked, so now I just gotta make the 4 conditions. I didn't know you could use...

But in this case I lose the whole if condition then value structure and turn it into a three-way where clause, don't I? Or do you mean where int(right(PER,2))<4 acts the same as an if int(right(PER,2))<4 ?? I never heard of that. Maybe this is getting too complicated, isn't there a simple...

You got it, it's my first time using IIF. What i made in the expression builder is iif(condition, value if true, iif(condition, value if true, iif( ... and so on. Now that I posted the SQL for you though, I'm starting to see inconsistencies. MS Access translated my expression in...

Sure, but my problem lies entirely in this one expression. I'm trying to make it work in a plain new query with no joins or anything, just to select the quarters. Here is the query it's meant to be used in; SELECT Data.ClientID, Data.SorgID, Data.DivID, Data.BrandID, Data.DistChanID...

I made it in the expression builder, and it told me syntax was wrong when i used commas. It must be right since it runs. For example, i take the ">Left([per];4)*100 And <Left([per];4)*100+4" and run it on its own, i get the desired result.