Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
IIF statement to manipulate data - for QA
thank you very much -- pearce64
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
IIF statement to manipulate data - for QA
Hi all - any help much appreciated I' am trying to write a Query that will QA staging Data for Patients, in the output shown below. The sample below is only a small subset of the full dataset., and the records contained in my table. Either a query in QBF or a small function in VBA I don't mind...- pearce64
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Validation Check Across Multiple fields
name WHO0: WHO1: WHO2: WHO3: WHO4: check fred 1 1 0 joe 1 1 mike 1 1 steve 1 1 sarah 1 1 pete 1 1 ash 1 1 I have a table (matrix) which records...- pearce64
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Separating out Invoice Numbers
Newbie user question I have Invoice Numbers I wish to separate out into 2 lists. Some Invoice Numbers are numeric only (list 1), the remaining are alpha numeric (list 2). The letters of the alphabet (A-Z) could be contained anywhere in the Invoice Number (either upper or lower case). Also...- pearce64
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
