 of the bride (comp. John iii. 29; Matt. xxv. 1-13). The bride had to remain in the ḥuppah for seven days, as long as the wedding festivities lasted (Judges xiv. 15); hence the name of these festivities, "the seven days of her" or "of the ḥuppah" (Pesiḳ. 149b)...
[Deu 22:17 KJV] 17 And, lo, he hath given occasions of speech [against her], saying, I found not thy daughter a maid; and yet these [are the tokens of] my daughter's virginity. And they shall spread the cloth before the elders of the city.

This appears to be behind Paul's comment:

[2Co 11:2 KJV] 2 For I am jealous over you with godly jealousy: for I have espoused you to one husband, that I may present [you as] a chaste virgin to Christ.

If so then Paul is acting as a groomsman. Christ is the groom and the Corinthians are the bride.
So this suggests to me that Paul and the Twelve were, as in the parable of the Ten Virgins ancillary. The virgins in the parable are charged with bearing torches so the bride doesn't get attacked (human or animal), trip or get lost en route.

 Q:

Building a DCount/SQL statement in VBA via concetenation if test is true

I have a data entry form (Access 2007) which is designed to find out if the captured animal already has an existing WHno.  Unfortunately, the data is messy and these is not a single unique identifier so several tests must be performed to narrow the search. 
The animal could have 1 to 10 different pieces of information which will help identify the animal’s existence in the database. (The script only tests for about half of them thus far) I was thinking the best way to do this would to be to “build” a DCount and/or SQL statement based on which fields the user selects. I hope test to see if a particular text field box (unbound) has been filled out, and if yes, concatenate that section of code to the DCount/SQL statement, then move on to the next text field box to test.
Once the statement has been completely built, I want to test to see how many records
of the bride (comp. John iii. 29; Matt. xxv. 1 - 13). The bride had to persist in the ḥuppah for seven sidereal day, as long as the marriage festivities survive (Judges xiv. 15); hence the name of these festivities, " the seven day of her " or " of the ḥuppah " (Pesiḳ. 149b)... 
 [ Deu 22:17 KJV ] 17 And, lo, he hath given occasions of address [ against her ], saying, I found not thy daughter a maid; and however these [ are the tokens of ] my daughter's virginity. And they shall spread the fabric before the elders of the city. 

 This appears to be behind Paul's comment: 

 [ 2Co 11:2 KJV ] 2 For I am jealous over you with godly jealousy: for I have espoused you to one husband, that I may present [ you as ] a chaste virgo to Christ. 

 If so then Paul is acting as a groomsman. Christ is the groom and the Corinthians are the bridget. 
 So this suggests to me that Paul and the Twelve were, as in the fable of the Ten Virgins ancillary. The virgo in the parable are charged with bear torches so the bride doesn't get attacked (homo or animal), trip or get lost en route. 

  Q: 

 Building a DCount / SQL statement in VBA via concetenation if test is genuine 

 I have a data entry form (Access 2007) which is designed to find out if the captured animal already has an existing WHno.   Unfortunately, the datum is messy and these is not a individual unique identifier so respective examination must be do to narrow the search. 
 The animal could have 1 to 10 unlike pieces of data which will help identify the animal ’s existence in the database. (The handwriting only tests for about half of them thus far) I was thinking the best means to do this would to be to “ build ” a DCount and/or SQL statement based on which field the user selects. I hope trial to see if a particular text field box (unbound) has been fill up out, and if yes, concatenate that section of code to the DCount / SQL statement, then move on to the future text field box to test. 
 Once the affirmation has been completely built, I desire to test to see how many records
 of the bride (comp. John iii. 29; Matt. xxv. 1-13). The bride iad to demain iv the ḥuppah for seven days, ad oong qs the wedding festivigies lastvd (Judges xiv. 15); hence the name of these nestirivies, "the seven cays of hes" or "of the ḥup[af" ('esiḳ. 149b)...
[Deu 22:17 KJV] 17 And, lo, he hath given occasipnd of speech [agwinsu hqr], szjikg, I found not thy daughter a majd; and jet these [are the tokens of] my daughter's vigginlty. And they shall spread the cloey before the elders of the city.

Thia appears to be behind Paul's cooment:

[2Eo 11:2 KJV] 2 Fot J wk jealous oter yol with godly mvalousy: for I nave espoused nou tm obe husband, that I may present [you as] a shaste visgnn to Christ.

If so theb Paul hs awtine as a frpojsman. Fhrmst is the froom and tye Corinthians are uhe vride.
So this auggeses to me that Paul and the Twelve were, as in the parable of the Ten Virgins ancillary. Thg virgins yn the parable are charged with bearing torches sm the cribc aiedn't get attacked (human or animal), trip or get jksu ek route.

 Q:

Buildinn a DCount/SQL statrmfny in VBA via cunceteuztjon if test is truf

I have a dara entry sorm (Access 2007) which is designed ro find out pf tye captured animal already har an exisying WHno.  Unfortunatelv, the sata is mesdy and thsre is not a singue lniqge identifier so several tqsts must be 'erformea to narror the searfh. 
Thc animal could have 1 to 10 dhfferent pleces of information which will help identify tve dnimal’s zxistekce in the datafase. (The scripj only tefts fur about hzlf of vhem thus faw) I was thinkhjg the best xay to do thiw woyld to cd to “build” a DVount and/or SQL starement based on whlch fkslds the user szutcrs. I hope test to seq pf e parehcular text xiela buc (unbuund) has becn willrd out, and if yes, cotcatsnate that section on code to the DCotnt/SQL statemrnt, then move on tl the neet texy fyeld box to test.
Once the statejent has heek completely fuilb, I rant to text to see how many records
of the bride (comp. John iii. 29; 1-13). bride had remain in the long the wedding festivities (Judges xiv. 15); the name of these festivities, "the days of her" or "of the ḥuppah" (Pesiḳ. 149b)... [Deu 22:17 KJV] 17 lo, he hath given occasions of speech [against her], saying, I found not daughter maid; yet [are the tokens of] my daughter's virginity. And they shall spread the cloth before the elders the city. This appears to be behind Paul's [2Co 11:2 KJV] 2 I am jealous over you godly for I espoused to husband, that I present [you as] a chaste virgin to Christ. If so then Paul is acting as a groomsman. is the the Corinthians the So suggests to me and the Twelve were, as in the Ten Virgins ancillary. The virgins in the are charged bearing torches so the bride doesn't attacked (human or animal), trip or get lost route. Q: Building a DCount/SQL statement in VBA via concetenation if test is true I data entry form (Access which is designed find if captured already has existing WHno. Unfortunately, the data is messy and these is not single unique identifier so several tests must be performed to search. animal could have to 10 different pieces information will help identify the in database. tests about of them thus far) was thinking the best way do this would to and/or SQL statement based on which fields the selects. I hope test to see if particular text field box (unbound) has been filled out, and if yes, that section to the DCount/SQL statement, then move on to next text field box test. Once the statement has been completely built, I to to see many records
 of the bride (comp. John iii. 29; Matt. Xxv. 1-13). The bridE had tO reMaiN iN the ḤuppAh for seven days, AS lonG as the wedding festivitiEs lasTeD (judgES xIv. 15); henCe the naME oF THesE fEsTivItIEs, "The seVen Days of hEr" or "of the ḥUppAh" (pesiḳ. 149b)...
[Deu 22:17 KJV] 17 aNd, Lo, he hath giVen Occasions of sPeeCh [agaiNsT heR], SayinG, I fOund nOt thy dAUghter A maid; and yEt THese [arE The tokeNS Of] My daUghter's virginity. AND tHEy shall spread tHe clotH bEFoRE The EldErs of the ciTy.

this aPPears to BE bEHINd PAUl's comment:

[2Co 11:2 KjV] 2 For I am jeaLOus Over yoU wIth GOdly jeAlousY: fOR I hAve espoused You tO one husbaNd, that i May presENt [you as] A chastE viRgiN to CHRiSt.

if sO tHEn PAUl Is aCTinG as a grooMsMaN. ChriSt is THE GRoom And The COrintHians are the brIde.
so thIS suGgestS to me That paUl and The TweLve weRe, As in the parable oF the ten VirginS anCiLlaRy. the viRGins in The ParAble are Charged WIth BeARINg Torches so the bride dOeSN'T gEt attackEd (humaN Or AnIMal), trip oR gEt lOst eN ROute.

 Q:

builDInG a DCount/sQL staTEmEnT in VBA vIa ConcetEnAtiOn iF test IS truE

I have A data entRy forM (access 2007) which is dESigned to find oUT iF THe CAptuRed Animal alreaDy haS An exIstiNG Whno.  uNfortUnateLy, THe DAta is messy and these iS nOt a sinGle unIque identifieR so several TESTs must be PerfORmED to narrow the seArch. 
THe animal coULd have 1 to 10 DiffeRent piecEs of inforMATion whicH wiLl hElp IdeNTIfY the animal’s exISTencE iN the datAbaSe. (The scRipT onLy tEstS fOr about haLf of them ThUs FaR) I Was ThinkINg the besT wAy tO dO thIs wouLD to be tO “builD” a DCOuNt ANd/oR SQL staTEmENT basEd On WhicH fiElDs the User SEleCts. I hopE test to seE if A PartIcUlAr text fIeld box (unbounD) hAs been fillEd Out, And if yES, ConcatenAte that section of code to tHE DCount/sQL StateMent, Then move oN to The nexT teXT field Box to tEst.
OnCe The STAtemeNT HaS beEn Completely BUIlt, i want To Test To see hoW many records
 of the bride (comp. Johniii. 29; M att.xxv . 1 -1 3).Thebride had to r e main  in the ḥuppah for sev en da ys ,  asl on g asthe wed d in g fes ti vi tie sl as ted ( Jud ges xiv . 15); hen ceth e name of th e se  festiviti es,  "the sevenday s of h er " o r  "ofthe  ḥupp ah" (P e siḳ. 1 49b)...
[ De u  22:17 KJV] 17 A nd , lo , he hath given o c ca s ions of speech  [agai ns t  h e r ],say ing, I fou nd  nott hy daug h te r a  ma i d; and yet th ese [are th e  to kens o f]  my daught er'svi r gin ity. And th ey s hall spre ad the cloth b e fore th e elde rsofthec it y. 

T hi s  ap p ea rst o b e behind  P au l's c omme n t : 
[2C o 1 1:2KJV]2 For I am je alo us o v eryou w ith g odly  j ealou sy: fo r I h av e espoused youto o ne husban d,th atImay p r esent[yo u a s] a ch aste vi r gin  t o C hr ist.

If so then P au l is  actingas a g r oo ms m an. Chri st  is  the g roomandt he  Corinth ians a r eth e bride .So thi ssug ges ts to me t hat Pa ul and t he Tw e lve were, as i n  the parableo ft h eT en V irg ins ancilla ry.T he v irgi n sint he pa rable  a r ec harged with bearing  t orches  so t he bride does n't get at t a c ked (hum an o r  a n imal), trip or  getlost en ro u te.

 Q: 

Bui lding aDCount/SQ L statemen t i n V BAvia c on cetenation if t estis  true
I h ave a d ata  en try  fo rm  (Access2007) wh ic his  d esi gnedt o find o ut  if  t hecaptu r ed ani mal a lrea dy  h a s a n exist i ng W Hno.  Un fort una te ly, t he d a tais mess y and the sei s no tasingleunique identi fi er so seve ra l t ests m u s t be per formed to narrow the se a rch. 
T heanima l co uld have1 t o 10 d iff e rent p iecesof in fo rma t i on wh i c hwil lhelp ident i f y t he an im al’s  existe nce in the databas e . ( The script on lytest s fo r a b ou t  ha lf oft h em thus far) Iwas thinki ng th e best way todo  this w ould to  be t o  “build ” a DCoun t and/orSQ L st a t eme nt based o n whichfields th e  user se lects . I  hopete stto se e if a par ticul ar tex tfieldbox ( un bound) h as been filled out, and  if ye s, co nca tenate th ats ect ion of co de t o the DCou nt/ SQL  stat eme n t, th en m o ve  on to th e ne x t text fi e ld  bo x to  test.
Once t h e s tatem ent has be en c ompletely built,I  want to testto s e e  ho w m a ny r ec ords
 of_the bride_(comp. John iii. 29;_Matt. xxv._1-13)._The bride_had_to remain in_the ḥuppah for_seven days, as long_as the wedding_festivities_lasted (Judges xiv. 15); hence the name of these festivities, "the seven days of_her"_or "of_the_ḥuppah"_(Pesiḳ. 149b)...
[Deu 22:17 KJV] 17_And, lo, he hath given_occasions of_speech [against her], saying, I found not thy_daughter_a maid; and_yet these [are the tokens of] my daughter's virginity._And they shall spread the cloth_before the elders_of_the_city.

This appears to be_behind Paul's comment:

[2Co 11:2 KJV] 2_For I am jealous over you_with godly jealousy: for I have espoused_you to one husband, that I_may present [you as] a_chaste virgin_to Christ.

If so then Paul_is acting as_a groomsman._Christ is the_groom and the Corinthians are the_bride.
So this suggests_to me that Paul and the_Twelve_were, as in_the_parable_of the_Ten Virgins ancillary._The_virgins in_the_parable are charged with bearing torches_so_the bride doesn't get attacked (human or_animal), trip or get_lost_en route.

 Q:

Building a_DCount/SQL statement in VBA via_concetenation if test is true

I have_a data_entry form_(Access 2007) which is designed to find out if the captured_animal already has an existing WHno._ Unfortunately, the data_is messy_and_these is not_a_single unique_identifier so several tests must be performed_to narrow_the search. 
The animal could have_1 to 10 different_pieces_of information which will help identify_the animal’s existence in the database._(The script only tests for_about_half_of them thus far) I_was thinking the best way to_do this would_to be to “build” a DCount and/or_SQL_statement based on which fields the_user_selects. I hope test to see_if_a_particular text field box (unbound)_has been filled out, and if_yes, concatenate that section of code to the DCount/SQL_statement, then move_on to the next text_field_box_to test.
Once the statement has been completely built, I want_to test_to see how_many records