By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,478 Members | 1,526 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,478 IT Pros & Developers. It's quick & easy.

access query error

100+
P: 111
Expand|Select|Wrap|Line Numbers
  1. SELECT DISTINCT [Grant Information].Contact1Index, Contacts.[last name], Contacts.[first name], Contacts.[middle name], Contacts.[whole name], Contacts.prefix, Contacts.Suffix, Contacts.[street address], Contacts.[street address2], Contacts.city, Contacts.state, Contacts.zip, [Grant Information].[project long title], tblStatusCloseout.[approved project end date], [Grant Information].[project short title], Budget.[federal calculated total], Staff.[Whole Name] AS PMName, Staff.email AS PSEmai
  2. FROM ((([Grant Information] INNER JOIN Contacts ON [Grant Information].Contact1Index = Contacts.ContactIndex) LEFT JOIN tblStatusCloseout ON [Grant Information].[Grant Index] = tblStatusCloseout.GrantCloseoutIndex) INNER JOIN Staff ON [Grant Information].[Staff Index] = Staff.Staff_Index) LEFT JOIN Budget ON [Grant Information].[Grant Index] = Budget.[Grant/Budget Index]
  3. WHERE ((([Grant Information].Contact1Index)=[forms]![Main Data Entry]![Contact1Index]) AND (([Grant Information].[project long title])=[forms]![Main Data Entry]![project long title]) AND (([Grant Information].[project short title])=[forms]![Main Data Entry]![project short title]) AND (([staff.title])="Program Manager" And ([staff.title])="Program Specialist"));
Can anyone tell me what is wrong with this access query? I started getting error when I entered two new fields called PMName and PSEmail. This query is control source for a report and it shows me an error when I run the report.
Jul 28 '09 #1
Share this Question
Share on Google+
1 Reply


100+
P: 111
anyways I figure it out. You cannot have two conditions at a time. Either Prgram Manager or Program Specialist. Both does not work
Jul 28 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.