Search results

I have an table in MS Access in which I have got date wise sales figure for different product in three different columns (one column for date, one for the product code & the third for sales figure). I want the program to find the last "sales figure" for a particular product in the sales column...

Dear Brianwarnock Sorry for the delay, but I was stuck up in something urgent. I tried your solution but couldn't able to get the result. Here with I am attaching an excel sheet. Can you please add the code there & post it here so that it will be easier for me to get this sorted out. Sorry for...

Dear Brianwarnock Thanks for your prompt reply & valuable suggestion. I'll try the method you have suggested & get back to you if I face any problem (this may take 3 to 4 days as I will be out of town on some official work). Anyway thanks once again Regards

Dear All Thanks a lot to all who has replied in the post & I apologize for the delay in my reply. As it is clear from your replies that the solution lies in VBA , but VBA is like Greek & Latin to me. Can anybody help me regarding how to use the solution & where to put in the code? Thanks &...

DATE SALES_IN_TON SALES_LESSTHAN_TODAY'S 16/04/2010 846.3 19/04/2010 847.15 846.3 20/04/2010 857.65 847.15 21/04/2010 851.25 22/04/2010 851.7 851.25 23/04/2010 822.95 26/04/2010 811.95 27/04/2010 810.2 28/04/2010...

I have an Excel sheet in which I have got date wise sales figure in ascending order(oldest to newest) in two different columns (one column for date & the second for sales figure). I want the program to find the last "sales figure" in the sales column (by going backward) which was less than...

Thanks pbaldy Hope this solves my problem. I will get back to you if I encounter any problem. Anyway thanks a lot

Hi everybody I have a problem in access & am really stuck with it. I want to do some basic calculation (addition, subtraction etc..) between fields involving more than one rows. At present I am pretty comfortable writing expression in queries involving two or more columns. what I want is...

Hi I have been using MS-Access for last few months. Although it is a wonderful application, I found you need to have the knowledge of VBA to extract the full potential of the application. I tried the help file but it seems that it is written for the advanced user & not for beginners like me...

Dear Brianwarnock I'm really sorry if it seems from my post that I am not listening to the seniors regarding creating a third table. However I have created the third table as suggested by Dave & lagbolt. I defined one-to many relationship from masterorders & suborders to the order details...

I have a separate table for master in which I have a list of all the master order, let's say 20. This table contains information regarding the clients who have placed that particular master order. Now lets assume I have 5 suborder for each master. Then it adds up to 100 orders which I have saved...

Dear Lagbolt Thanks for your prompt reply. I understand these two field have many-to-many relationship & I have also defined them properly. My database is working pretty well for other issues. I have problem with the lookup column only in which I am doing some mistake somewhere in the...

Hi I have a database in which I have one table for master_order_no & another table for sub_order_no & other details. Both the tables are linked by one-to-many relationship from master_order table to sub_order table through the master_order_no. One master_order_no can have nos of different...

Hi Pat Hartman I just have the same problem as Mr Rahulgty. I like the approach you have given in your post. But I am not being able to apply in practice. I have read help files but unable to use the DMax function in table field. If it is not too much pain for you then can you please elaborate...

Dear SOS I went through the link provided by you. But I didn't understand it a lot. As I am new to access, it will be helpful if you elaborate a little "BEFORE UPDATE" & "DATA VALIDATION" in a form. Thanks a lot in advance.

Dear SOS & FraserC Tahanks to both of you for your kind suggestion. I will use both the methods & post my experience soon. Thanx again for the support.

Thanks SOS I want to use charts in my reports. Can you show me how this can be done. Thanks again for your prompt reply.

Is there any way to use charts/graphs in Access-2007. I want to make some charts/graphs for my database as I used to do in Excel, but I am unable to do so. I have tried with Access help but unable to find the chart option. Any help please......?

Thanks SOS for your suggestion. But it will be more helpful if you elaborate a little about the procedure for data validation. B'coz frankly speaking I've not used a form in my database. Regards

Dear Trevor G Thanks for ur suggestion. But I think it wont solve my problem if I use a query, because I need to enter data on a daily basis on the mentioned table. Actually I need to enter the dispatch qty for every shipping & I want the dispatch qty should not be more than the Balance Qty...