Recent content by arohulich

Vince, I really appreciate you hanging in there and trying to help me. Your queries work great on A2K, but the problem is that the SQL CE doesn't support the expressions within the SUM function, ie - Sum([TableName].[Attrib]="Pass"). I am beginning to wonder if a Simple query is going to work...

Vince, As it turns out the left join is not supported in SQL CE so I am trying to modify your SQL such that it does not require the left join. EMP, provided a neat solution except that the -Sum([TableName].[Attrib]="Pass") portions of the query also is not supported in SQL CE. Currently I am...

As it turns out the -Sum([TableName].[Attrib]="Pass") function is not valid in SQL CE. Back to the drawing board. That was sure a clean solution if it worked. Thanks for trying... Regards, Alan

Thanks everyone for your help! It looks like that last append will work, just need to figure out an alternative to the Format command. It is not supported in SQL CE, everything else is. Regards, Alan

Vince, More info - I re-tried your query and it works if I add a column called status to the table. I will look at extending your thoughts to include my new requirements as stated in my last reply. Thanks for the "off the top of your head" reply it was GREAT! I wish my "off the top my head"...

Vince, First of all, Thanks for the quick reply. It is a single table with several fields that is being queried. My client wants to create an output table with five fields as I just found out this morning. It would look something like this: The input table looks like this: Org ! Loc ...

I have a single table with several fields representing inspection count data. One of the fields has pass / fail as its data. If I generate a Select statement using a UNION function between the items that pass vs fail. The result set lists multiple items as the corresponding fields along with the...

I am creating an application which is using VB.NET. On the form I have two listboxes. The one listbox is bound to a master table in Access 2000 (MasterBldg). The second listbox is bound to a selection table (SelBldg) which is related to a client table via a primary/foreign key relationship. I am...