Re: Query

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Arvi Laanemets,

I am not able to understand the formula. Mainly why you have used the
Min formula. Can I use the following part of the formula :
=DATE(YEAR(A1),MONTH(A1)+A2,DAY(A1))

Please give an example to illustrate when the above formula will give
wrong result and why.

Thanks a lot for taking interest in my query.

Sumit

.

Relevant Pages

  • Re: Query
    ... > Hi Arvi Laanemets, ... > Please give an example to illustrate when the above formula will give ... > Thanks a lot for taking interest in my query. ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Create table from query?
    ... I would like to add some information to a query. ... if i run the query again the additional data will be lost. ... Below I'll try to illustrate what i mean: ... Prev by Date: ...
    (comp.databases.ms-access)
  • Re: Identifying fields out of order
    ... Click on "Create Query in Design View" ... tblSeq AS Prev, tblSeq AS Next; ... Our SQL now would look like: ...
    (microsoft.public.access.queries)
  • Query based on Column Index
    ... I have attached the sql to a query that I have developed. ... regarding the TraitHistory fields. ... Prev fields from my table and update the query. ... query determine the Curr and Prev based on their position in the table. ...
    (microsoft.public.access.queries)
  • Re: Multiple field query
    ... > I need a query that will give me single column list produced from all 20 ... > the opeation fields. ... EdS ... Prev by Date: ...
    (microsoft.public.access.queries)