Search results

i guess i found my answer in forum. http://www.access-programmers.co.uk/forums/showthread.php?t=214559 and this is someone wrote in this thread : http://www.baldyweb.com/LastValue.htm

the question is how can i determine ? Normally i need this kind of code : i really dont know how can i write sql code like this... :(

Hello Friends, I have same Problem again. Last time i could find a solution because only 1 Field was enough to show and count to all Records. Now i need again like "DISTINCT" or "Summation symbol" but i don't have only one Field to show at this time.... If i take to my Query only 1 field...

and this is the other example. May be Version problem ?? or try to open it right mause click and run as an administrator

actually i opened your DB and on my Access is looking everything just normal. If it was the problem of course.. I checked other queries too.. It shows just normal. My Access version is 2007-2010

Hello My Friends, I wrote so basic a macro and bound up with a Button. Im exporting Excel Sheet from my companies Program and importing to Access. Everything is functioning automatically. But when I try to import Excel Sheet Im getting run time error 3709. :banghead: I checked Import Error...

okey thanks i ll try it.

Hello My friends, i checked from Forum and found many Thread about this Problem. May be i could not understand good but unfortunately i did not find my answer.... Normally this code is working. But it´s too complex because my code is getting bigger and bigger. May be you can find any...

Thank you very much gentlemen:) It was more sophisticated but i did it. Just need to create 1 more table and 2 extra query :)

hello my friends, i have a query and there is ID Groups and Milestone. I need to somehow compare them. (please Check the picture.) On this example i have 2 different ID (1 and 2) and these IDs have many Groups. PS: Milestone : C > B > A i need to compare with same ID Data Records but...

I cant send content of my DB. Somehow i must explain... i ll try and try and try. If i send any of records that ll be end for me at this company and i can go in jail. And if i create for every question different DB, i must work on DB forever. That's why i will try to explain again : my...

you should check 2. picture to understand my data records to understand. and yes i mean 2. one. For P102345 => actual 28.02.2016 but there is 11 different Appointed date (closest Appointed Date to Actual Date) thats mean 17.03.2016 is closest Appointed Date for this ID. If i talk about...

I dont need to difference. I ll send better example. May be i can explain myself much better. (im sending 1 more picture.) Project, Actual, Appointed P102345, 28.02.2016, 17.03.2016 P102390, 31.12.2015, 26.01.2016 P102405, 31.03.2016, 26.04.2016 These are closest Actual and Appointed Dates...

I want to only closest dates. for me there ll be only 3 Date records. Others are not relevant. I don't wanna see not relevant records. Of course Actual Date can be variable. P100911, 20, .... 31.12.2015, 26.03.2016 P100911, 30, .... 31.12.2015, 26.03.2016 P100911, 40, .... 31.12.2015, 26.03.2016

Hello friends, Hope so you can help me as soon as possible. Please Check my picture : You can see there same ID number they all same. Those ID's have Groups (A) at this picture only 3 different groups 20 30 40. Actual Date and Appointed Date. (Others not important now.) I need to compare...

okey thank you namliam i found my fail. i was using () thats why wont work....

those names are not my choice. im using a database who had built before me

hi thank you for answer but i recalculated with this formula PET MTB: IIf([T1_alle_Details_pro_Änderung]![PET]> ([T1_alle_Details_pro_Änderung]![FET]+([T81_ursprüngliche Termine Datensaetze identifizieren]![ursprünglicher Ziel PET]-[T81_ursprüngliche Termine Datensaetze...

Hello friends, I know my title is looking so complex, actually i could not find right words. Anyway : in my query i built a mathematics operation : Result MTB: [T1_alle_Details_pro_Änderung]![FET]+([T81_ursprüngliche Termine Datensaetze identifizieren]![ursprünglicher Ziel...

there is no data. I guess thats why it cant find any connect between dates. Im sending my result and query. ps : The query and field names are german. Hope so its not a big problem.