Search results

wao. Thanks!!! i got the desire results. Thanks again.

What i need from your given data set is as below: MasterItemID Price PriceDate VendorID 1 2 2/5/14 30 1 2 2/5/14 32 2 3 1/1/14 30 In your sample data there rare chance that Price is always same so either in first 2 records we have either 1st record or 2nd based on low price.

The table has no primary key. I would like to get whole columns where Price is low against each MasterItemID.

Hello, I would like to select records based on Minimum values of specific vendor. Example: MasterItemID Price PriceDate VendorID 1 2 2/5/14 30 1 3 2/5/14 31 1 7 2/5/14...

Thanks for your reply. I have achieved the task but using another method. The method you have described is not full-filling my requirements because i only want to update table1 if there is max date in Table2.

I understand it well dear, but I need to solve this problem. Have you idea about the stated problem.

Hello experts, I would like to achieve the following task described below: Just for an example i have two tables = Table1 and Table2 Table1 contains following fields: ID , CusName, Price , Date_ Table2 Contains following fields: ID, CusName, Price, Date_ I would like to update Price and Date...

Thanks for your suggestion. Your suggestion of dlookup works fine. Thanks again.

Please see the attachement

Please see the attached database. Using the form when Enter door Sale i would like to populate bonus% according to value in Door Sale. Techs table contains the criteria for bonus%. Thanks Note: Database size is more than 2 mb but less than 3 (after zip) .. how can i send to you.

Thanks for you suggestion and you really understands what i want. I will implement try to implement it but can we not achieve this with Switch statement so that our code part reduced. Actually there might be chance to increase in columns for work done(as you see in my earlier post snap shot).

Thanks Vonik. Your mentioned query working perfectly... Thanks again.

Thanks of your reply. But I can't keep both tables in one because they have different fields. I have just showed the sample table. My Table1 contains about 30 fields and Table 2 contains 74 fields. I only wants to take one column data into Table2 by keeping ID field.

Hi, I am using ms access for entry of data of AC technicians. All Technicians can gain bonus amount in % if they work well and bonus % is dynamic for each technician. Suppose, Technician Mr.Jhon work for $300 or above so his bonus % is 5 and if he done work of $800 or above then bonus % is 9...

Hi experts, I am facing problem regarding updating of certain field of table. For example i would like to take data from a column of Table1 and would like insert that data into particular column in Table2. Suppose Table One has data: Table 1 ID Name amount 1...

Hi, I have an ms access Database(2013 version). There are about 10000 records. There are some columns with field property of "short text" but contains the values like that 0.4,7, 9.0 etc I would like to convert the "short text" into "double" without loosing information. Can i do that using any...

Thank you very much.

Thanks pbaldy and Steve R.. Mr.Steve R. I don't know how to use MySql or Sql Server Express as back end. Can you more guide me or give me link of tutorial to do so and also for front end to develop. Thanks

HI, I have developed an ms access program having tables, forms, queries, macro and some vba code. I would like to run application over LAN for 3-4 computers along with different User rights. Suppose, Manager can View Reports at any time on his computer, Data entry Operator view(for data entry...

Hi, I have small database in ms access which i am using for invoice creation. When invoice is created i save it as PDF. I would like merge another single Page PDF along with the report as 2nd page so end report is 2 page PDF. Second how can i get 1 PDF from 2 ms access reports. Thanks for...