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 because the donation was made by a company, so I want to use an if statement that will make the query pull the company name from the table if the donor name is blank.
This is in access 2007 and the current query is coded thus:
SELECT [Contributors Extended].ID, [Contributors Extended].[Contributor Name]
FROM [Contributors Extended]
ORDER BY [Contributors Extended].[Contributor Name];
What should I add to it?
Thank you in advance
my issue is that some of the donor name fields are blank because the donation was made by a company, so I want to use an if statement that will make the query pull the company name from the table if the donor name is blank.
This is in access 2007 and the current query is coded thus:
SELECT [Contributors Extended].ID, [Contributors Extended].[Contributor Name]
FROM [Contributors Extended]
ORDER BY [Contributors Extended].[Contributor Name];
What should I add to it?
Thank you in advance