Search results

Nevermind, I was able to fix it. The query that the report was using was pulling from another query. I had no reason to believe that that was part of the problem, but for the sake of trying anything and everything I decided to have the secondary query pull directly from the original table...

This became a problem when I made the "Committees" list an access table. The committees lookup used to pull from an excel spreadsheet because the people in the company were already using excel to keep track of the committees. I changed it to an access table because I figured it would be easier...

I have a report that pulls data from a query. One of the fields in the query is called "Committees" and pulls from a lookup field in a table. The lookup allows multiple selections because many of the board members are in multiple committees. Also, this Committee lookup field pulls from a...

I have to go home now, but I'll post it tomorrow morning. Thanks a lot for the help

More briefly the row source is [Contributors Extended].[File As], the code I sent before merely displays the company name if the contributor name is blank, which you helped me with a couple of weeks ago if you remember...

SELECT [Contributors Extended].ID, IIf(Len([File As] & "")=0,[Company],[File As]) AS [Volunteer ID] FROM [Contributors Extended] ORDER BY [Contributors Extended].[File As]; [File As] is used to format [Last Name] & ", " & [First Name] from the contributors table. I use this so the combo in...

I noticed that in the combo box in the volunteer form that pulls from the contributor names has a column width of "0";1"". When I changed this to just "1"" the number displayed in the form instead of the name. Now when I go into the table design view and change the column width of the source...

Thanks for the quick response... They're all already formatted as 1", but I experimented with changing them anyway and it didn't work. Is there anything I could code in sql and stick in the query that would display the [Contributors Extended].[Contributor Name] that pertains to the Volunteer_ID...

I'm making a database for a non-profit and I have a volunteer table attached to an volunteer input form. In the volunteer form there's a drop down box that pulls from a "contributors extended" query. "Contributors extended" has a column that takes the last name and first name columns from the...

http://file2upload.com/download/15198/0596527608.zip Good book... "Access: The Missing Manual" many other pdf access books at... http://www.ebookee.com/search.php?q=access&sa=Search

Yeah, I was thinking that (that Nz or IsNull didn't apply to blank strings), but I wasn't sure nor did I know how to code it in SQL. That worked perfectly, thanks for saving me from further aggravation... +1 for pbaldy's rep... also nice atlas shrugged quote

Thanks for replying so quickly, I tried that and I still got the same result... First I tried it exactly as you typed it although I knew it needed editing Next I tried: SELECT [Contributors Extended].ID, Nz([Contributor Name], [Company]) AS Contributor Then I tried: SELECT [Contributors...

I'm making a simple membership database for a nonprofit org. When a new donation is entered there is a drop down box that shows all of the current members in the database. It's populated by a query that pulls the names from a table... my issue is that some of the donor name fields are blank...