Search results

Thanks for your reply , I doubted it as well so i will stick to my basic design with removing grouping and try to add index to the filtered field , Thanks for your patience

Guys someone gave me this solution (Thanks a lot to him) would it be faster than my queries ? (In Theory) SELECT t2.PoNumber , Nz(MAX(IIF(t1.Type='Material', t1.Code, NULL)), 'None') AS MatCode , Nz(MAX(IIF(t1.Type='Material', t1.Item, NULL)), 'None') AS Mat ...

ok thanks to all , I will try in the main database and see how it goes

Thanks for the information , This design is very slow already with considerable set of data , Thats why i’m looking for new design to make it faster , Could you please look at this thread you will see the result of my design so slow...

Ok I will , Thanks

Up

Thanks for reply , I agree with you , my way is more acceptable because we are looking for a way to make it faster and i don’t think your way will pull it . But in the end my technique caused a disaster here...

Hello guys , I have a query which need to simplify and still give the same result but faster , Please find attached query " Result " which joined with 4 sub queries , I need to cancel those 4 sub queries and still get the same result. Note: The attached database is a sample db , the main db...

Thanks all it was very helpful , It Worked out for me

Sorry guys for the wrong Maths , About the example above i have read it in a website with this exact syntax.

Hi Guys , I need to add a numeric field value to a specific hour but i faced a #Func problem , what i need to do is add for example 3:20 hours to 8:00 AM the 3:20 is the result of the expression [DaysRemains]*24 : Hrs:DateAdd("H:N",[DaysRemains]*24,"8:00:00 AM") Where is the mistake , thanks

Thanks good idea

Sorry i got your reply wrong i thought you meant tap groups, You are right the tag property could be the way but i haven’t used it before

Thanks for reply , I don’t want to use that because my design have a side menus so i need to keep the design as it is , i need a flexible way to deal with them.

Hi guys , Let’s say i have a 100 command buttons and images in an access form i need to deal with them as groups for example in English : Group1 includes commandbutton1 To Commandbutton10 and Image1 To Image10 me.group1.visible = false The result would be hide buttons from 1 To 10 and...

You have been a great help thank you so much , I will start working on the points you all mentioned . I can’t thank you enough

About this i made 5 queries because of the 5 reasons are used in the same line in the search form , If i used your way i will have to use IIF statement to deal with that one merged query to choose the SerialNumber for Example : IIF([SerialFormat]="Num1",[Reason],"") This IIF will be used 5 times...

I got it thanks man i will do as you explained , I have learned many things from your reply thanks.

Thanks for your reply , I added the form used in search . About edits need to be done I already have tried as much as i know about queries :( , Thanks for your help

Hi Guys , I have a very slow query (Even slower in splitted database_be) tried every thing to speed it up but in no vain , Please find attached the query mentioned name ResultFinal . Thanks in advance