Search results

hi wiklendt, hope you will fine.. i have a question about last conversation how i can protect Report sheet except prod. date cell

thanks wiklendt i replied little bit late because i was analyzing the sheet that you have created by entering my data, how it will be beneficial to me.. and i found it great and so much helpful to me. thanks again if any help required i will contact to you can you give me your direct contact

Yes absolutely right.....for todate column But for today column opening will be change on daily basis regarding last date closing...

dear your answers are.. 1:- i am not a broker, i am working in process industry in production department 2:- i am using multiple sheets to generate a production report 3:- currently its on my personal computer therefore no one have access , its my personal file due to which not on any server...

hi wiklendt, are you have study my case? is there any progress...?

as i said that i am stater at access, therefore i did not have multi table relations, i tried to update my database but it is not happened because of forum limitations, as my file size is 4.75 mb what can i do? i have uploaded my file, i want to update my production data daily basis please...

I will be thankful if you will help to resolve my problem

Thanks for Your Time I got the point, I was thinking that access tables are like a excel spreadsheet cells

all of this is performing very well in excel, i want to do all this with access due to access vast functionality, what i have to do to get these results???????????

Yes, you have got now In the today column always change opening/closing daily bases but in todate column opening/closing on monthly basaes and sums the quantities of today's receiving/issues in todate column on daily bases. Please take seriously my problem to resolve

Its so easy you explain, that I also knows I want to relate these controls to the date, bcos if I not relates my database Will behave abnormal bcos rbdclbaltoday is also exist in today column. When I will relate to the date it will become unique and not disturb today's data...... Please review...

there are attachments pics that may express my issue

column Today = A column Todate= B first equation is crdopbaltoday=crdclbaltoday of previous day(i.e 13th aug, 2015) second equation is.. crdopbaltodate=crdclbaltodate of previous month(i.e 31st july, 2015) third equation is..... crdissuesoaptodate=crdissuesoaptoday+crdissuesoaptodate of...

hi thanks for your time, here is the db again with requirement

hi everyone please help how i can solve this issue please give me the full syntax for each function

Thanks for your time, Please what will be the complete syntax, if the field names are, Proddate, & Reportdate, My wish is when I type or insert date in proddate, reportdate shows +1increment every time automatically

i want to add next date automatically i have two field with name of A and B, my requirement is when i add the date in field A, field B shows me the date with +1increment(day) automatically what will be the syntax i am new to access 2007