Can somebody please look at this statement and correct it

[Mansoor Ahmad]

Here is the statement. Please can you correct it for me.

DoCmd.OpenReport "R_Fuel parts summary monthwise", acViewPreview, , "[ANALYSIS DATE] = > #12/31/1999# " Or "[ANALYSIS DATE]Is Null" And [Warranty parts type] = " #Fuel# "
OrderBy ([ANALYSIS DATE])


[ANALYSIS DATE] is a date field
[Parts type] is a text field
Want to filter the data by '>12/31/1999' on [ANALYSIS DATE] and
by text 'Fuel' in [PARTS TYPE] field


I am not good in VB codes. I have tried it myself but as I do not have clear concept of using '," ,& and other notations so I could not fix it myself.

Thanks

 

[Mile-O]

DoCmd.OpenReport "R_Fuel parts summary monthwise", acViewPreview, , "([ANALYSIS DATE] >= #12/31/1999# Or [ANALYSIS DATE] Is Null) And [Warranty parts type] = ""Fuel"" OrderBy ([ANALYSIS DATE])"

 

[Mansoor Ahmad]

Thanks a lot for your reply.

I will try in on Monday now. Its been enough for today here. I want to go home now.

Thanks