Search results

Dear all Greetings, Just a small question. I have a database (Access 2003 and I am using it with Access 2007 with user level security) on shared folder on internal Dell server and I have created a shortcut to each user's machine to access it. This days I am facing a problem of db size as every...

Dear all Greetings, We have our own accommodation for our employees and each room we have 3 bed spaces like Room G01 = 3 bed spaces Room G02 = 3 bed spaces We are assigning employees to each room and currently using simple excel spreadsheet to assign employee but most of the time we are...

Dear all Greetings, I have an employee table with employeeID and site defined (DB attached). I have another table “attendance”. I just want to feed attendance with concerned employeeID with their pre defined site and if I entered attendance for concerned employeeID with wrong site (different...

Dear all, I have a query with field of [DateofJoining] I want to create another field and want to see the value that what date will come after 22 months for that [DateofJoining] field. Please advice.

Hi all, I am trying to use Dsum criteria with multiple values but it's not working for me. Please see below I am trying to sum up 4 state's total but its not working for me. =DSum("[S/G(M)]","QryCurrentRequirements(ClientHeads)","[State]=2 Or 4 Or 6 Or 7") Please advice.

Dear all I am a learner with access database. Please find attached database. Things are working fine and I am still developing it but in between I got a problems as below. •If someone work 25 Days as code N means normal days and 1 day as PH means public holiday and it supposed to be a NormalDays...

I have a calculated subform in form where in subform in the footer area I put =Sum([GrandTotal]) and its giving me an exact value of -39 after the calculation. I want to show it in form I put correct formula to show that value in form but its showing error. I put...

Dear all, I am developing KPI for my office (please see the attachment). How can I get score and result in sheet. I have around 1200 staffs. Please advice.:confused:

Dear All, Please see the attachment. I want to get a Sum of Duration (mean total hours for that particular date), I simply put Sum in Total field of query but it's showing some error. Please advice.:confused:

Hi all, I open my 2003 database from access 2007 and try to see the forms which was alreday designed in 2003 but i can't see it. Later on again I open same database from 2003 and found that my whole forms deleted automatically from the database. No idea how this happen. I tried to open it in...

Dear all, I have a database in access 2003, now we move to office 2010. Can I still use that 2003 database in access 2010?? If yes than how to use?? or I have to forget about my 2003 database? Please advice.

Dear all, Please see the attachment. I want to get a NormalDays from ANormalDays. I want to make 26 days in NormalDays If ANormalDays is 26 or 27. I put a condition like that but showing that Query is too complex. :confused: Please advice.

Daer all, How do I use Round Function in query? As I put below function in my query but its showing (53.5384) Which I want to show 54 only. NonDeployedDaysEarned: Round([BasicAsPerState]+[StateFoodAllowance])/26*[NonDeployedDays] Please advice.

I have a query where I have a field NormalDays and SickDays. I want to calculate if someone has Less than 26 days than it will take rest days from SickDays like below NormalDays = 24 SickDays = 4 I put function like IIF([NormalDays]<26,[NormalDays]+[SickDays],[NormalDays]) But in...

Dear all, My ascending order is not working in query and it's showing randomly (April 2011 and than March 2011 and than May 2011). I have a query with month and year. Please advice how can I fix it. SELECT Format$([AttDate],"mmmm yyyy",0,0) AS [Month], QryDailyAttendance.AttendanceType AS...

Dear all, I had already shared my database on the server with ULS. It is working nicely when everyone is in the office but the problem is everyone is having their own office laptop and once they left the office and took their laptop with them and come back next day than again I have to shared it...

Dear all, I have a report monthly depends on different employee ID numbers (One ID number have one report). Is it possible to send each concerned report to their respective email ID at one time? Please advice.

Dear all, I am trying to share my db into the network but getting problem. Please see the attached message I am getting. Please help me out.

Dear all, How can I filter Months in query as I have a date in format as below January 2011 February 2011 March 2011 January 2011 February 2011 March 2011 I want to filter previous month (say March 2011). I tried {Month(Now())-1} but not working. Please advice.

Dear all, Please see the attachment. I am struggling with criteria. Please advice for the solution.