Table =a/r trans
field =insrcd (allow zero length=yes)
insfrom=""
insto=max value of insrcd in a/r trans file
query:
where (nz([a/r trans]![insrcd],"") Between [Forms]![arledger]![insfrom] And [Forms]![arledger]![insto])
I am trying to select all records, regardless of insrcd.it does not select any records where the insrcd is empty. I assume because it is zero length.
Also tried:
where (nz([a/r trans]![insrcd],"") Between nz([Forms]![arledger]![insfrom],"") And nz([Forms]![arledger]![insto],""))
same results, records without an insrcd are not selected.
What am I doing wrong?
using Access 2003/ windows Vista
Thanks for helping
Sarah
__._,_.___
Posted by: sarahk@schemesoftware.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Yahoo Groups
Improved Group Homepage!
The About page of your Group now gives you a heads up display of recent activity, including the latest photos and files
Yahoo Groups
Control your view and sort preferences per Yahoo Group
You can now control your default Sort & View Preferences for Conversations, Photos and Files in the membership settings page.
.
__,_._,___
Tidak ada komentar:
Posting Komentar