To do a 'wildcard' for numbers, you can default the number to say -1 then in the where clause you can put something like this for your areacode or any...

You can play with this to try to get it to work,

=iif(RowNumber("table1_Group1") Mod 2, "Green", "Blue")

The problem I have is if there is only 1 record for the group, then...

Just a follow up, the fix from the link works.  You will have to close EM and reopen it for it to work.

According to this page, http://users.spark.net.gr/~yiapap/bldiagra.htm, seems that it is caused by ADO 2.8.  I haven't tried it yet.

This is what happens when people who are clueless make laws.  Many shops have developer and DBA as one in the same.  Why should smaller shops be required to hire...

As does sp_server_info.  My problem is @@version returns SP4 as the service pack for the OS and sp_server_info returns SP3.  My question is is this a problem that I should...

I think the higher ups are way off base.  We just completed our S-O audit and we basically have to have an audit of who logged in and documentation of...

You could use something like this:

execute LOOKUP 'MR_MEMBER' 'O' + char(39) + 'Brien'

Just a thought.