Re: sort out one months

You need to be able to ask more complete questions. We don't know if your
table or tables have any date fields. Also, we have no idea how you
determine if a project is "completed".

Apparently you think we can either see your application or read your mind.

--
Duane Hookom
MS Access MVP


"Rowl" <Rowl@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:387F1372-7216-4EE6-BAEA-DA790F57BB32@xxxxxxxxxxxxxxxx
>I have a database of projects. I need to see just projects completed in
> specific month how can I make query etc.


.

Relevant Pages

  • Re: Creating a temporary table/query for subform
    ... Any object name beginning with "usys" is not displayed in the database ... MS Access MVP ... I cannot let this temporary table or query show ... find any help in the MS Access help on how to do this in VBA. ...
    (microsoft.public.access.queries)
  • Re: Report Query
    ... Access MVP 2002-2005, 2007 ... choose not to) then you can use a "normalizing" union query to return the ... You should be able to use that query as the source for your report. ... Now, with that being said, short of rewriting my database, can anyone ...
    (microsoft.public.access.queries)
  • Re: Refer to a form in a pass-through query
    ... I don't know the syntax for whatever database engine you are querying. ... MS Access MVP ... The name of the query is PKLQ. ... SQL in Access. ...
    (microsoft.public.access.queries)
  • Re: Query 2 databases
    ... Is [Stock Number] a kind of stockID while ProductStock a quantity, ... The query works fine, for that purpose, when only one field is to be used as 'criteria' for finding un-matched records. ... Vanderghast, Access MVP ... The second table is in second database. ...
    (microsoft.public.access.queries)
  • Re: Use of Nz Function in Queries
    ... Post the SQL statement of the query that you're using.... ... <MS ACCESS MVP> ... > shows the months with no records due to these desires months there weren't ... > and what other conditions or controls properties do my database must has ...
    (microsoft.public.access.queries)