Search results

Conceptually, I have the following two tables: Table 1: Group | Item ------+------ A | 1 A | 2 A | 3 A | 4 B | 1 B | 2 B | 5 C | 1 C | 2 C | 3 Table 2: Item ----- 1 2 3 I'm looking to return only Groups which contain all Items...

I'm in the process of designing an application which will source data from 5 separate tables (each subject to selection criteria), combine fields from each table, and finally append the records to another table. Since each of the source tables contains a large amount of data (on the order of...

Thanks - I didn't know this was possible!

I wasn't aware of this, but after some testing I can't seem to confirm this:?typename(dcount("*","myTable")) Long?dcount("*","myTable") 3 ?dcount("*","myTable")=3 True ?dcount("*","myTable")="3" True

Many thanks Minty. So, to confirm: in VBA, one cannot assign a value to a variable within a test expression - is this correct?

Thank you for the suggestion, but I don't think I could use a Select Case expression in this circumstance, as the various test expressions are referencing different data (I understood that Select Case can only test a single item of data).

No - I tested the second example, however I received a type mismatch error and so I thought I may have the syntax incorrect. Though, with more experimentation I think I may have answered my own question: it seems that a variable assignment in VBA does not return the value assigned to the...

Hi All, A pleasure to be a new member of this forum; prior programming experience, but relatively new to VBA so I apologise in advance if my questions appear neophytic. This should hopefully be an easy one: As part of an existing if/elseif block, I'm look to test whether a table contains...