Search results for query: *

Thanks! That was perfect

I am creating a report that is using a query, and would like to have certain fields visible depending on if a field is null or not. For example: If var2 is not null, then var1 should be invisible and var2 should be visible. If var2 is null, then var1 should be visible and var2 should be...

The vars are all coming from the same table.

Is there are function that exists that allows me to compare a number of different date variables, that may or maynot be null, the output being the max date of the variables. For example: Var 1: 2/21/2006 Var 2: null Var 3: 2/15/2006 Var 4: 2/15/2005 And I would expect get the date of 2/21/2006.

Thank you that worked perfectly!

You can add a filter to a form that will only show records that have a null or active status (depending on how you set up your status column).

I have a combo box that contains id, first name, and last name, where id is the bound column. In a later form I want to populate a name field using the first and last name of the record selected in the combo box. I would like to use the setvalue function in a macro but can't figure out how to...

I need advice on taking multiple selections from a list box and applying those selections to the criteria for a query that controls report data. I more or less want to filter data on a report from the selections in a list box. I'm not afraid to use code.

I have data that may not include complete dates. The month or day may not be known. How can I keep the date/time format but allow the month or date or even the year to stay blank? For example, 09/_ _/2004 or _ _/_ _/2003