Search results

Sorry , I try to avoid them ny using underscore but sometimes I forget ..will correct them

Hi all , I have a query in which I need to filter only current month records , but using Month(now()) it is not filtering . Below is my SQL , can you tell me how to do this? SELECT [OT and Absenteeism by month].[Date of Entry By Month], [OT and Absenteeism by month].[Sum Of OT (hrs)], [OT and...

Yeah ...Even here in our office ...persons with slightest health upset are advised to take compulsory 5 days leave & if anyone found to return after attending a mass gathering are not even allowed inside the office .All these measures are even making the panic higher.

Yeah you are right , (already ordered curfew against mass gatherings etc) But in some report I read that Italy situation is worse due to high percentage of elders in the country?

Hi everyone , India , Apart being 2nd highest populated country & still economically devlopping , I thing we are still in good position in terms controlling the "community spreading" of this virus.. what are your views?

Thank you for your reply, And I do know that records which have due will show the due date . but the problem was even if it is due ,title & assigned to was visible & due date was not , made some changes in SQL and now it is good. Thank you so much for your help.

Thank you so much , will look after it.

Thank you , I created a query as you told but the field due date is showing as empty.

Dear all, In my main menu form I have provided a button to check the tasks due as a reminder. In this assigned to field is coming as number , because in in my table it is of number type & it is linked to contact table to retrieve the data. So in my message box I need this number to be...

Okay have a safe trip

Thank you for your reply , In this case I can't give the user this freedom to select the relevant types. As he could miss one type of gauge & it may result in rejection. Hence the user interface must look like this: The form has a combo box of material number which has the source at matser...

Sorry , I was bit busy in meeting preparations hence I couldn't see your reply. I studied(only concept) the EAV database structure and as you suggested it will store only non-zero items hence makes the databse compact & structured. I will study bit more today & I will work on this.(kindly...

Sorry for my late reply... As the DB contained confidential info , I made a crude db containing the same pattern. Could you please look into it , & please explain me how could my request can be accomplished.

Thank you for your reply...and the table structure is not the problem...I am outside now..once I am home I'll attach the DB...I think that will help me to get your help.

Dear all, I have master table field where I have 21 coloumns 1 material number 2 gauge type(type name in the coloumn heading and reading will be entered in the fields) In the gauge type I have total 20 types .but each material number should only be checked using the guages specified in the...

Thank you , As you said the property of the attachments field was OLE instead of attachments , after changing it is working properly.

Dear all , I just downloaded a template from Microsoft access 2016 called task manager , in which if I click the button " add or manage attachments " the following error is showing , however I changed the functionality from macro to vba to manage attachments , I want to know why is this error...

Thank you , I will revert back after reading the post.

Thank you for your reply , I have saved for the first time when I added the totals row .But after I closed and open it it is not showing .then if I click totals button it apperas . I have attached my database you can see the total complaints trend query

Dear all , I have include totals roe for my queries by using totals function at the top of the ribbon , but sometimes as soon as I close & open my database , the row has to be again added by clicking the same function on the ribbon. Is there any way to make the row stay there permanently ??