Recent content by ash1123

If it is not mandatory to use SINGLE table, then it's better to use with two table. isn't the concept is same like "Purchasing different product under same invoice?" if so, only then possible for me.

Almost there .. just need to see the SEARCH counting like before. trying based on your. let me try .. want to learn

Thanks for your hopeful reply and will wait for your return. note that, i think i can do next part but if possible you help me with this when i put 2nd key word it will come to next row of previous search. it means in the second row. Thanks in advance.

Re: Splitting "sum" column into two columns, depending on value of another colum BassettProvidentia pls use thanks button to thank, it will be highly appreciated.

dear, Your design is simple fine, just join the primary key to the foreign key. make form. make the foreign key as combo box which has a source from a query based from related tables. I think you will be able to do. thanks

Dear JR I'm talking about "addsearch" query and "search" field. I'm trying to describe in more details, hope will not make u confuse. 1. not all data will be showed up, cause i'm unable to find which one i'm tracking. 2. If i put keyword "World history" it will showed up in the subform and...

Dear tanya It will be much help if you can upload the form or at least snapshot. My problem is that I cant seem to access the filtered patient from the MergeForm.>> what is the Merge form based on?? Aren't you using combo/dropdown for Patient selections?

Chk this, this might be done in several ways depend on your demand chk the new form

I would like to say... you are not lost, but just need to be more logical. need your logic just for example: Be Curious, Be Scientific (2nd-7th) ... 1.where is 1 session 1 period? 2. what do you mean by Class ID? 3. If you want to put a student to any specific Class, put him to specific Class...

Dear lacey, if you take care your query i think you may able to find that your Combo is just working nothing but a filter of Table:Class, your Yes/No option is part of Class table not Student. More: when you are running query it is not recording, it just showing your status of classes table...

did you tried Group by ?

Dear DC27, It will be much help if you upload the spreadsheet sample. and the expected data manually putted into a single row. Let me try though: 1) did you tried by fixed format of like dd/mm/yy, cause it might happen that when you are exporting your data, excel sheet is taking the cell format...

"addsearch" query that you helped me with database combo-search database.. let me describe in deatail (hope it will not make you confuse) 1. if i search with "world history" , data will retrieve in the below table in ROW1 showing "Search" field as 1 2. if i search with "Dhaka city" , it will...

Dear JR, I need your help again after long 3 month as i thought i could manage your solution. Problem is, it was just fine, but lately i'm facing problem cause my Data is getting larger. so what problem i'm facing is... I can't find out which "search" number is getting higher than the "SHELF"...

It's a great step for me..... will do bit changes on trigger timing... but thanks JANR, was a window to a dark room