Recent content by SteveV

Pat, Thats a slick fix, it works great! In case anyone else needs to do this here is the actual syntax you need to use for your SQL statement: SELECT Table1.firstfield,=Choose([numberfield],"One","Two","Three","Four") AS Whatever, FROM Table1; What this does is convert an integer number in...

I have a query that is returning a numeric value for a field. I would like to convert that number to a specific text string. For example, if the query returns a 1 then I want the query to display the word Pass, if it returns a 2 then display Fail etc... I was tring to use a Case select statement...

PCS, I am a little confused about what you mean to "split the query" do you mean use a sub query. Can you post an example? Shacket, your fix would probably work but the syntax is incorrect and all Access gives me is a SQL error. Can you give me the correct syntax?

I need to return a query that returns a distinct value in only one field but I need to display two other fields: Here is my data: Run BNumber SNumber 84 KB743 17 95 KK546 13 95 HG435 55 56 AW546 33 I only want unique run numbers, so the record for 95 should only show...

Set up a query and specify = Event ID in one criteria and = Event Name in another field of the search. If you set up the Event Name to be the one event and the Event ID to be the secound I believe this will work. Give it a shot, if it doesn't work email me your DB and I can try it.

Is there a way in Access to return every 10th record in a table?