Need Some help

  • Thread starter Thread starter John Farr
  • Start date Start date
J

John Farr

I don't know if this is the right group to post this to....

I am using Access 2002 to work with MS SQL 2000 tables in a DB. One of
the tables that I am working with looks something like this...

User ID Name Date
1 John 2/4/2004
2 j37dhewys 2/4/2004
3 Jane 2/4/2004
4 348Om7d3j 2/4/2004
5 Sara 2/5/2004
6 u3H672JJh 2/5/2004

What I want to do is Query just the ODD User ID's so that when I
execute the query I get just the Real users names and not the
usernames and not the hash. It should look like this...

User ID Name Date
1 John 2/4/2004
3 Jane 2/4/2004
5 Sara 2/5/2004

I hope that I explained this ok.

Thanks,
John
 
I don't know if this is the right group to post this to....

I am using Access 2002 to work with MS SQL 2000 tables in a DB. One of
the tables that I am working with looks something like this...

User ID Name Date
1 John 2/4/2004
2 j37dhewys 2/4/2004
3 Jane 2/4/2004
4 348Om7d3j 2/4/2004
5 Sara 2/5/2004
6 u3H672JJh 2/5/2004

What I want to do is Query just the ODD User ID's so that when I
execute the query I get just the Real users names and not the
usernames and not the hash. It should look like this...

User ID Name Date
1 John 2/4/2004
3 Jane 2/4/2004
5 Sara 2/5/2004

I hope that I explained this ok.

Thanks,
John
Click to expand...
As criteria in the userID column:
[UserID] Mod 2 = 1
 
Create a query and put the following expression in the first field of the query:
OddUserID:[UserID]Mod2
And put this for the criteria of that field:
<>0

Next change the name of the Date field tp something other than "Date'. Date is a
reserved word in Access and using it as a field name will cause problems!

Finally, put the Name and Date fields in the second and third fields of your
query.
 
Back
Top