Search results for query: *

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]&...

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...

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...