Access Database Value Retrieval

[Sparky Arbuckle]

I have the following sql statement, typically it would grab a specific
value but I also want to be able to grab all values within the
database. Can I use the same SQL statement? I thought I could just use
* and pull everything but that doesn't appear to work.

SELECT tblRacers.RacerID, tblRacers.strLName, tblRacers.strFName,
tblRacers.strAgeCat, tblRacers.strRaceCat FROM tblRacers WHERE
tblRacers.strAgeCat='" & strAgeCat & "' AND tblRacers.strRaceCat='" &
strRaceCat & "';

I thought if the value passed in for strAgeCat/strRaceCat was * it
would pull all but I guess that isn't the case. Any suggestions on how
to approach this?

Thanks!

[Bhavesh Patel]

Hello

I don't know what you are stored in strAgeCat but you can form your query
like this.

SELECT tblRacers.RacerID, tblRacers.strLName, tblRacers.strFName,
tblRacers.strAgeCat, tblRacers.strRaceCat FROM tblRacers WHERE
tblRacers.strAgeCat like '% " & strAgeCat & "%' AND tblRacers.strRaceCat
like '%" &
strRaceCat & "'%" ;

However this is not the proper solution but we can fetch all the records
from the database not setting the value of strAgeCat/strRaceCat. I mean in
the absense of the values the query we shall have tblRacers.strAgeCat like
'%%' and so will get all the records.

I think it may work for you.

regards,
Bhavesh Patel
"Sparky Arbuckle" wrote:

I have the following sql statement, typically it would grab a specific
value but I also want to be able to grab all values within the
database. Can I use the same SQL statement? I thought I could just use
* and pull everything but that doesn't appear to work.

SELECT tblRacers.RacerID, tblRacers.strLName, tblRacers.strFName,
tblRacers.strAgeCat, tblRacers.strRaceCat FROM tblRacers WHERE
tblRacers.strAgeCat='" & strAgeCat & "' AND tblRacers.strRaceCat='" &
strRaceCat & "';

I thought if the value passed in for strAgeCat/strRaceCat was * it
would pull all but I guess that isn't the case. Any suggestions on how
to approach this?

Thanks!