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...
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
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...