Search results

Dear Experts! I am trying to develop a simple software and stuck with criteria to calculate some fields. I have attached a sample excel file for your kind review. Can anyone help me in this regards without SQL.:banghead:

Oh no. I am not able to open when i rename it to accdr. Is there any specific reason for this? I have a linked excel and a query from that excel in the database.

Yes but it doesn't open.

Can you please share the link to download the new release

Hi Experts! I have deployed my access database with an excel linked to the database. Excel is in my desktop. But when i tried from another PC in which Access runtime 2013 installed am not able to open it. Error showing as attached. Can any one help me to fix it. Tried some registry location and...

Oh Perfect!!! Thanks a ton dear!!!

Can anyone help me to resolve this please!:banghead:

I tried Abs((DateDiff("d",([ToDate],[LeaseStartDate])*12/364*[MonthlyRent]) but even then its not giving the right figure.

Yes for better understanding please find attached the excel sheet where the figure highlighted in red showing 7714.00 but as per the formula you provided the amount is showing 13000.00 1. Data Type is : Date 2. dd/mm/yyyy

Thanks for your Quick help on this! However, date diff calculation went wrong! I think its the issue with "*12/364". Any workaround for this?

I was trying to transform the excel formula to access. =IF(AND($B$13<Q21,Q21<$D$13),($D$13-Q21)*S21*12/364,IF(AND($B$13<R21,R21<$D$13),(R21-$B$13)*S21*12/364,S21))

Can any one help me to fix the formula Monthly Cost: IIf(AND([FromDate]<[LeaseStartDate]<[ToDate]),([ToDate]-[LeaseStartDate])*[MonthlyRent]*12/364,IIf((AND([FromDate]<[LeaseStartDate]<[ToDate]),([LeaseEndDate]-[FromDate])*[MonthlyRent]*12/364,[MonthlyRent])):banghead:

Dear Arnel, Could you please look in to my thread. http://www.access-programmers.co.uk/forums/showthread.php?t=290391 Thanks in advance Paul Cherian.

Dear Experts! Can i omit one column value and make a total in cross tab query. I have attached a sample screen shot for better understanding. From the column heading i need to get a total of all columns starting from "CROMPTON" till "TTC". Total should not include the "QDVC" Count. Could anyone...

How can i find a freelancer to complete my work? Do u have some suggestions?

Paul, So there will not be any limitation in concurrent users if i choose sql as back end and access as front end? If so how will i manage various levels of time attendance approval workflows and workflow management. Can be done through access and sql?

Hi Arnel, Can you comment on the below link: http://www.access-programmers.co.uk/forums/showthread.php?p=1501454#post1501454

Any experts to tell me a best solution to implement a system in place with workflow approvals and time attendance submission process. Can MS Access cater my needs? Is that practical to deploy Access runtime version to 900+ employees to collect their monthly attendance.:confused:

:banghead:

Thank you all!