|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 12th, 2009, 11:38 AM
posted to microsoft.public.access.queries
|
|||
|
|||
Parameter Query Null Response Error
I have some parameter queries in which I enter a [Month] as a criteria. I
also want to be able to return all records if I want. I have seen the instruction on adding an OR line with Like [Month] Is Not Null under the original criteria. I run this from design view and it works as it should but the second OR line statement does not save on exiting the query. It has vanished when I go back in to check. What have I done wrong? -- Message posted via http://www.accessmonster.com 
|
|
#2
July 12th, 2009, 12:09 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Parameter Query Null Response Error
Bruister wrote:
I have some parameter queries in which I enter a [Month] as a criteria. I also want to be able to return all records if I want. I have seen the instruction on adding an OR line with Like [Month] Is Not Null under the original criteria. I run this from design view and it works as it should but the second OR line statement does not save on exiting the query. It has vanished when I go back in to check. What have I done wrong? I meant to say Like [Month] Is Null. I have entered it correctly but still does not save! -- Message posted via http://www.accessmonster.com
|
|
#3
July 12th, 2009, 12:58 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Parameter Query Null Response Error
Like [Month] Is Null won't result in valid SQL. Assuming you've got a field
named, say, TransactionMonth in your table, put Like [Month] Or ([Month] Is Null) as the criteria under it. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Bruister via AccessMonster.com" u50445@uwe wrote in message news:98f5b6aa990d0@uwe... Bruister wrote: I have some parameter queries in which I enter a [Month] as a criteria. I also want to be able to return all records if I want. I have seen the instruction on adding an OR line with Like [Month] Is Not Null under the original criteria. I run this from design view and it works as it should but the second OR line statement does not save on exiting the query. It has vanished when I go back in to check. What have I done wrong? I meant to say Like [Month] Is Null. I have entered it correctly but still does not save! -- Message posted via http://www.accessmonster.com
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
