Search results

Thanks It worked But will it have any adverse effect on any other thing ?? :confused:

Thanks I will try this but I don't know from where I can download "the patch from the MS Knowledge base"

Hi I have created some reports but find difficult to keep permanganate page set up for that reports. I go to design view and do page setup with required margin and Portrait or Landscape set up and preview that reports looks fine. After saving again I check still its fine but once I close that...

Thanks Pat But couple of times I tried to use module or Function it did not work may be I don't know exect way to use it in Forms or Report I will keep trying Thanks again

Thanks Pat I will keep this in mind but I am not using Public Functions or Modules because of lack of knowladge but will be keen on learning the same so if you can suggest Website or Samples of Datbase to look Sandip

Hi Pat Thanks again But I did found some solution In my main query I made Expression field as Start Date: Format([date]-Weekday([date],2)+1,"mm-dd-yyyy") End Date: Format([date]-Weekday([date],2)+7,"mm-dd-yyyy") which gives me Start date(Monday) and End date (Sunday) This I can use any time to...

Still waiting to get some help on above Thanks Sandip

Thanks Pat My problem is now I need Start date and End date of that week numbers to print in that report such that eg. week no 43 of 2004 Start date 10/17/04 and End date as 10/24/04 so I need to convert week no. to start date and end date(Reverse of Datepart("ww",[date])) I don't know how to do...

Thanks Partly problem solved as I came to know extraction of weeks but still i have to work and think how to total pertcular field on week basis and in report display start and end date for the same My actual need is like this I have Patients data who takes treatments every week, some patients...

:confused: Hi I want to make query which should give sum or total or Avg on week basis instead of Unique Date/Time,Day,Month,Quarter or Year If anyone can help ( I need Sum from Monday to Sunday) Sandip I need detail for full year on weekly basis not only for any selected week

Previous Record For calculation Thanks Loos very good site will try to learn from it Hi Still i could not resolve my problem. Can any one post simple database zip file so i can open and understand the same

Previous Record For calculation Thanks But I Tried for Joh K's Post but could not find can any one can post sample database in zip form so i can view and can learn

Hi My problem is i am making one simple application for Inventory I need to know how can i use previous records data for calculation Example I have received 10 units on 1/1/03 and used 5 on 1/1/03 next day i have received 7 units and used 2 units so my balance stock will be 10-5+7-2 = 10 so how...