Search results

The Doc Man Thanks for your time. My reports are to be generated from my query so I do not have to update the table as such. I wanted to bring out the general picture of what I want to achieve. This is what I have now: MyTable ID Fa Fb Fc Fd Fe Low 1 4 7 1 2 6 2 3 4 7 8 5...

Hi The Doc Man I Have created the queries as per the code you attached. MyUnion works right MyBottomTwo gives an error; "syntax error in ORDER BY clause" MySum gives an error; "you tried to execute a query that does not include the specified expression 'Fx' as part of an aggregate function...

Thanks NauticalGent. I want to sum rows. Thanks sxschech the refered to web site failed to open but lets see whether I shall be able to tame your code to what I want. Extra help is welcome. Thanks very much The Doc Man It is true I want to be able to select from row data and then be able to...

Thanks NauticalGent. I have no problem with; -Ranking, Summing Top "n" or Bottom "n" in column Data. I have a problem summing Row data. I have visited the site you refered me to but I have not figured out how to sum up bottom "n" for data Rowise.

I would like to be helped to write a code in VBA that can sum Lowest 2 values in a query of 5 field values, and have this sum placed in a separate field "Low" for each row. qryLower2: ID ; Fa=1 ; Fb=2 ; Fc=3 ; Fd=4 ; Fe=5 ; Low=3 i.e Low=Fa + Fb

I have designed something for you. Hope it works. Create two blank forms; "Startup" and "Main Form". Attach this code to Startup - On Load. Secure the code by right clicking on the project in the VBA Editor, select protection and enable this. Go ahead and set the password. Call me on...

You will send to me your Email. Mine will be available when my post count comes to 10. I shall send to you access 2003 LockFileMaker.mdb, MainFile.mdb,LockFileTemplate.mdb. The LockFileMaker shall be able to generate LockFile.mde and MainFile.mde. The LockFile shall carry the limitations in...

Try creating a Print command button on a separate form with your report connected to the button. Hope you know how to do this.Go to devices and printers, Dbl Click on your Printer, Select "Customize your printer",Click Advanced, Tick "Hold mismatched documents". Go ahead and print your report.

Originally Posted by Tragac011 IIf[Broj dana]<=20>=15,5,0,IIF[Broj dana]>=20,10,0)) Try this: IIf([Broj dana] Between 15 And 20,"5", IIf([Broj dana] >=20,"10","0")) Note: I do not know how to code IIf([Broj dana] Between 20 And "Infinity"

Hi I am an Access 2007 User. I do make Databases for Schools, Hospitals, Shops etc. but ofcourse I get stranded at times and I hope this Forum will be Helpfull.