Hello, in MS SQL I can do something like this to query a table base on multiple parameters with some of the parameters being null.
Given my statement below is it possible to do the same in Access SQl 2003? If so how?
Select * From Surveys
where (rtrim(@CompanyId) is NUll or rtrim(CompanyId) = rtrim(@CompanyId))
And (rtrim(@Platform) is NUll or rtrim([Platform]) like rtrim(@Platform) + '%')
And (rtrim(@SurveyNumber) is NUll or rtrim(SurveyNumber) like rtrim(@SurveyNumber) + '%')
And (rtrim(@Year) is NUll or rtrim([Year]) like rtrim(@Year) + '%')
Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)
This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…