Query Help...please

From: Phlip (aplatfl_at_microsoft.com)
Date: 01/21/05 

Date: Fri, 21 Jan 2005 12:07:23 -0800

I am using the following query that is not returing the
results I need.

SELECT * FROM
dbo.MonthlyUnapprovedTime
WHERE EmployeeID = 123456
AND uMonth <= datepart(m,'5/1/2004')
AND uYear <= datepart(yyyy,'5/1/2004')

On the table below

[dbo].[MONTHLYUNAPPROVEDTIME]
 ([MU_ID] [int] IDENTITY (1, 1) NOT NULL ,
  [EmployeeID] [char] (3) [int] NOT NULL ,
  [uMonth] [int] NOT NULL ,
  [uYear] [int] NOT NULL ,
  [UnapprovedTime] [decimal](5, 2) NOT NULL)

And I am only getting data for Umonth (1,2,3,4,5) and
uYear (2004). The data has every month and years from
2001 - 2005. How can I retrieve the missing data? Any
questions or idea is greatly appreciated.

Philip

Relevant Pages

  • Re: Showing records with one or more null fields
    ... , Countas NumB ... In the query grid, you would add all the fields you want to check and then put Is Null as criteria for each field. ... How can I run a single query that will show me all of the records that have missing data? ...
    (microsoft.public.access.queries)
  • RE: missing data
    ... Keith Bontrager - Bicycle Builder. ... Any way I can run a query with a function that fills up the two fields with ... missing data in the following format: ...
    (microsoft.public.access.queries)
  • Re: [PHP] Newbie question, Which way is best?
    ... My form sets up the query parameters. ... I want to use my pagination script to scroll, page by page, through the ... Then modify your PHP code to accept _GET values along with/instead of _POST values: ...
    (php.general)
  • Re: missing data
    ... missing data in the following format: ... run an Update query updating Line_ID to ...
    (microsoft.public.access.queries)
  • Re: Find Missing Data
    ... recommend constructing a query that pulls out the missing data. ...
    (microsoft.public.dotnet.general)