date reporting

[brianjay]

I have a database with a start date and an end date (neither are time stamps). I want to report only those items that "DO NOT" have an end date. How do I do it?

Thanx,
brianjay

 

[lupins46]

Create a query and set the criteria for the end-date field to Is Null. If you want to create aa Access report then use the report wizard and specify the query as the source.

 

[synapsevampire]

Try:

Report->Edit Selection Formula->Record

isnull({table.field})

-k

 

[brianjay]

To lupins46:
The DB is a MySQL db somewhere in Texas (i'm in MD). I can't create a sql query with access because I can't connect to the db and the CR10 sql editor is VERY confusing to use. I believe that the db is wacky.

To synapsevampire:
It seems that the "not isnull" funtion worked great. Pulled the 54 of 405 records fine, but the "isnull" fuction (which I need) won't work. Can't figure out why.

 

[lupins46]

Sorry BrianJay -I got lost among the forums - ignore my response.

 

[kskid]

How about

(
isnull({table.field}) or
{table.field} = ""
)

 

[synapsevampire]

Check the Database->Show SQL Query to see what's being generated to pass to the database. Post it here if you want help.

It's funny that a NOT(isnull({table.field})) would work, but not isnull()

MySQL is definitely NOT a ready for primetime database, but if Wichita's guess doesn't help (doesn't make sense that it knows what isn't null but knows what is), try:

not(NOT(isnull({table.field})))

<chuckling>

Worth a shot...

-k