Dear Manoj,
Please use it..
SELECT Month, Store ID
FROM [Acer All Data]
WHERE ((Month)="apr'12"));
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Fri, Jun 29, 2012 at 7:11 PM, ╰» ℓαℓιт мσαнη wrote:
> Hi Manoj,
>
> Try this
>
> select [store id] f
Hi Manoj,
Try this
select [store id] from [Acer All Data] group by [store id]
select [store id] from [Apr'12] group by [store id]
select [store id] from [Mar'12] group by [store id]
select [store id] from [May'12] group by [store id]
Regards,
Lalit Mohan
On Fri, Jun 29, 2012 at 3:14 PM, Manoj
lto:talk2mar...@gmail.com]
> Sent: 02 May, 2011 5:13 PM
> To: excel-macros@googlegroups.com
> Cc: Prashant
> Subject: Re: $$Excel-Macros$$ Help in Access
>
> Hi Prashant,
>
> Find the attachment... I hope that it will bring unmatch as per your new
> tables...
>
>
Subject: Re: $$Excel-Macros$$ Help in Access
Hi Prashant,
Find the attachment... I hope that it will bring unmatch as per your new
tables...
Code:
SELECT Lanpos.Match
FROM Lanpos LEFT JOIN Bank ON Lanpos.[Match] = Bank.[Match] WHERE
(((Bank.Match) Is Null)) UNION SELECT Bank.Match FROM Bank LEFT
Hi Prashant,
Find the attached file.. I hope this will fulfill your requirement... We
can arrive it with help of union query by using following SQL codes.
SELECT Bank.card, Bank.aut, Bank.amt
FROM Bank LEFT JOIN lanpos ON Bank.[card] = lanpos.[card]
WHERE (((lanpos.card) Is Null))
UNION SELECT la
Dear All,
I am trying to create unmatch data query thru access. I have two tables
namly bank & lanpos, my qry is throwing only unmatched data from lanpos
table, where as I want unmatched data of both tables as my result
Please help.
Regards,
Prashant
--
Dear Vikas
Please find required info on below mention link
http://www.techonthenet.com/top10/access.php
On Sun, Mar 28, 2010 at 2:35 PM, Vikas Chouhan wrote:
>
> Dear All,
>>
>>
>> Please help me in *access* please provide access queries and how to put
>> queries,,,
>>
>> *and how to vlook
> Dear All,
>
>
> Please help me in *access* please provide access queries and how to put
> queries,,,
>
> *and how to vlookup,concatenate in access *
>
>
> --
> One Team One Dream One Goal
>
> Warm Regards,
> Vikas Chauhan
> E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
> 9911868518,
>
