Search results

Dear all, I create a different tables for my attendance DB (Please see attached mdb) Is it possible I can show it together in one query as attachment (Excel attachment)?? Please help me out as I am totally new in MS Access :confused:

Mr. B, My structure is like this please find the attachment. How can I put it together for report (as attached excel sheet)? Please advice.

Thanks again Mr. B I given that primary key in id no. and in date to avoid duplication for same id on same date as I have more than 1000 staffs to entered an attendance a day. And that attendance field is I have a separate table (code for the attendance like N, R, OT, S etc) I connect that field...

Mr. B, Please find the attachment and advice, I create a table in that way. Is it fine or need to modify some more? :)

Mr. B, Thanks a lot for the information will try in that way and will come back to you with outcome.

Hi CBrighton, Sorry I am bothering you again :) I am recently using attendance in ms access and my table structure is like (Please find the attachment) I want to create a separate table where I can store different amount for different designation (which I can calculate later on basis of...

Hi I am recently using attendance in ms access and my table structure is like (Please find the attachment) I want to create a separate table where I can store different amount for different designation (which I can calculate later on basis of attendance) but here the problem is even for same...

Thanks CBrighton, Will try in that way :)

Sorry :) Please find the attachment again.

Thanks a lot CBrighton, Will start doing same in future :) I thought in that way too that I will put those monthly values in one table with field of Month / Total amount and will update every month but how can I get those details monthly basis in the report from table?? That is another...

Hi CBrighton, Please check Report Overall. I create a query with sum of [Cost per month] where it is showing whole total value. Which I have called in the report, from there I am getting Grand Total = ([Total Fuel Cost]-[Total of Cost per month]) but the problem will come in next month as I...

Dear all, Please advice as I write down the criteria in report as below but is was telling that contains invalid syntax. =IIf([M]=[M],DLookUp("[Total Cost]","Monthly Cost Query","[Month of]='January 2011'",IIf([M]=[M],DLookUp("[Total Cost]","Monthly Cost Query","[Month of]='February...

Hi GalaxiomAtHome, Please attached db for your refference. Thanks.

Dear All, I have a database and in my database in the report I am getting total expenses by (Total of Cost per month – total expenses). But the thing is I am changing cost per month value every month with different value but rest of all details will remain same. Now the problem is if I want...

Thanks vbaInet it's done. I did like this =DLookUp("[SumOfCost per month]","Main Table Query") and now its working. Thanks once again :)

Thanks a lot. Thats true :) I think I did a mistake in query. Will come back to you soon with problems :)

Thanks a lot. Thats true :) I think I did a mistake in query. Will come back to you soon with problems :)

Hi all, Please see the attachments. I have a report where I allocated a certain amount for each vehicle. I just want to know how can I get that certain amount totals at the end of report as I Put formula as =Sum([Cost per month]) and it is not working and giving wrong values. Please advise...

Thanks CBrighton, Done, You are not much that bad what forum says :D. God bless u.

Thanks again CBrighton :cool:, That is exactly what I am looking for OT but I need to show Normal duty too where if someone is working for 28 days than OT will show 2 days but in an another hand I want to show Normal Total = 26.