Criteria Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a list of works that should be used in criteria fields for doing
differant queries? example; like,between... also how would I link two forms
so when is open inside the other they match id#'s Thanks
 
Tom said:
Is there a list of works that should be used in criteria fields for doing
differant queries? example; like,between... also how would I link two forms
so when is open inside the other they match id#'s Thanks

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Criteria evaluations: Like "s?ri?ng*" or Like "*string"; Between x And
y; =; <>; >; <; >=; <=; Is Null; Not Null (aka Is Not Null)

Access wildcard characters * and ? are replaced by % and _,
respectively, in ADO or other RDBMS.

Form/subform is linked by the Master Link Field and the Child Link
Field, respectively. These properties are in the subform control's
Properties dialog box under the Data tab (hint: double click the
subform control to see the Properties dialog box).

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQlQr3YechKqOuFEgEQLIqQCgoou4uuHUqPhfhg6Yf+P5P/WOLJAAoI27
rOJLkZZkF6OYpLpiTKEjDR67
=HCp1
-----END PGP SIGNATURE-----
 
Back
Top