Use the DLookup function to get the value of a particular field 
from a specified set of records.

pls attach ur file if u r not able to






________________________________
From: Vikas Chouhan <vikask...@gmail.com>
To: excel-macros@googlegroups.com
Sent: Sat, 27 March, 2010 7:00:34 PM
Subject: Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John  
Walkenbach.

how to put formula,lookup in access


On Sat, Mar 27, 2010 at 4:29 PM, Deepak Rai <daksh1...@gmail.com> wrote:

Hi Vikash,
> 
>Want help you want on Access ?
> 
>Regards,
> 
>Deepak
>
>
>On Sat, Mar 27, 2010 at 10:38 AM, Vikas Chouhan <vikask...@gmail.com> wrote:
>
>hi 
>>
>>Dear all please help in access urgent plsssssss
>>
>>
>>
>>
>>
>>
>>
>>-- 
>>>>One Team One Dream One Goal 
>>
>>Warm Regards,
>>Vikas Chauhan
>>E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
>>9911868518,
>>>>
>>"We can't Spell S_ccess without U" 
>>
>>Life is Very beautiful !!!
>>¨`•.•´¨) Always
>>`•.¸(¨`•.•´¨) Keep
>>(¨`•.•´¨)¸.•´ Smiling!
>>`•.¸.•´. 
>>
>>
>>-- 
>>----------------------------------------------------------------------------------
>>Some important links for excel users:
>>1. Follow us on TWITTER for tips tricks and links : 
>>http://twitter.com/exceldailytip
>>>>
>>2. Join our Facebook Group @ 
>>http://www.facebook.com/group.php?gid=287779555678
>>3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>>
>>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>To post to this group, send email to excel-macros@googlegroups.com
>> 
>><><><><><><><><><><><><><><><><><><><><><><>
>>>>
>>HELP US GROW !!
>> 
>>We reach over 6,800 subscribers worldwide and receive many nice notes about 
>>the learning and support from the group.Let friends and co-workers know they 
>>can subscribe to group at 
>>http://groups.google.com/group/excel-macros/subscribe
>>>>
>> 
>>To unsubscribe from this group, send email to 
>>excel-macros+unsubscribegooglegroups.com or reply to this email with the 
>>words "REMOVE ME" as the subject.
>>
>
>
>-- 
>Thanks, 
>
>Deepak Rai
>
>
>
>-- 
>>----------------------------------------------------------------------------------
>>Some important links for excel users:
>>1. Follow us on TWITTER for tips tricks and links : 
>>http://twitter.com/exceldailytip
>>2. Join our Facebook Group @ 
>>http://www.facebook.com/group.php?gid=287779555678
>>3. Excel tutorials at http://www.excel-macros.blogspot.com
>>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>>To post to this group, send email to excel-macros@googlegroups.com
>> 
>><><><><><><><><><><><><><><><><><><><><><><>
>>HELP US GROW !!
>> 
>>We reach over 6,800 subscribers worldwide and receive many nice notes about 
>>the learning and support from the group.Let friends and co-workers know they 
>>can subscribe to group at 
>>http://groups.google.com/group/excel-macros/subscribe
>>
> 
>>To unsubscribe from this group, send email to 
>>excel-macros+unsubscribegooglegroups.com or reply to this email with the 
>>words "REMOVE ME" as the subject.
>


-- 
One Team One Dream One Goal 

Warm Regards,
Vikas Chauhan
E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
9911868518,
"We can't Spell S_ccess without U" 

Life is Very beautiful !!!
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
`•.¸.•´.

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
 
To unsubscribe from this group, send email to 
excel-macros+unsubscribegooglegroups.com or reply to this email with the words 
"REMOVE ME" as the subject.



      Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! 
http://downloads.yahoo.com/in/internetexplorer/

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe from this group, send email to 
excel-macros+unsubscribegooglegroups.com or reply to this email with the words 
"REMOVE ME" as the subject.

Reply via email to