Search results for query: *

Thanks very much. It works! You all are terrific. Thanks for the support and assistance. --Kathy

Hi Duane, Thank you for your help with this. I copied and pasted the query you suggested into SQL and ran it. I get the following error: Syntax error (missing operator) in query expression 'User_ID Left(Gender,1)'. The word left is highlighted in the query when I get this error message...

I found the place to write the SQL, but I think I'm in over my head so I'm pasting part of the table structure, field names and results: Table: registration_ Fields: Type When selected, displays: user_id number gender Text (Male or Female) race1 Text (AmericanIndian) race2...

Hi Leslie, Can you give me an example? I'm just not getting this. I want to change the displayed values so I am not sure where that code is written. Thanks very much. Kathy

Hi Duane, Thank you for replying! Sounds like this is doable. I apologize in advance for my lack of knowledge--but where do I write this code? Is it in the query itself or elsewhere? Thanks again. --Kathy

I have a database with tables linked via SQL Server. The way the data is stored on the server is not useful for reports we must submit to our funder. I'm wondering if there's a way to have the data display differently. For example, one of the columns in the table is "Gender". Rather than...

Hi: I have created a report that creates a class roster. Sometimes, one of the fields (organization) contains no data. I would like to eliminate the blank line this produces in the roster but have not been able to figure out how to do this. Here's my code for the roster: =Trim([last_name]&...

Duane, Thanks very much. It worked! (I'm always so surprised when something works--I don't know why). I can now move on to my next tasks. Thanks for helping. I for one (and I know I speak for many) really appreciate it. --Kathy

Hi: I am using a query datasheet as a simple report. I want to take text data from three fields and combine them into one field (i.e. firstname, middleinitial, lastname). Is it possible to do this in a query? I have tried creating a report where I can do this easily, but my datasheet has 59...

Remou: I can't seem to get the link you provided to work. Will you resend? Thanks very much. Kathy

Skip--this is terrific. Thanks so much. I must admit that I feel like a dope now that I see how you set this up. Some days the old synapses just don't fire. Thanks again. --Kathy

I am creating a database of multiple choice questions that will be used to generate pre and post tests. The master test is currently about 60 questions in length, but will grow over time. Answer sets range on an average of 4-5 per question, and each answer set is different (unique to that...