Search results

Hello, I'm using an IIF statement to display the results of another expression I've created in the query (i.e. if one of them is blank, select the other). I'm getting a syntax error when running the query: SELECT [Credit Portfolio].[Credit Specialit Assigned], [Credit...

I feel dumb asking this -- but I've been banging my head against the wall all day. Here's the query: SELECT pipeline_won_lost.Business, pipeline_won_lost.[Primary Officer Last Name], pipeline_won_lost.Status, pipeline_won_lost.[Actual Close Date] FROM pipeline_won_lost WHERE...

So I will admit -- have NOT been working with Access for long (as well as VB)....but have a need, so ready to do whatever necessary to learn! I have a sales report that I generate each week based on a query, which relies on the input from a combo box on a form. This works great - but I have...

I have a query that uses the input from a form as criteria, which is then used in a report. The form input is a drop down based on another table. This is a sales pipeline report, and the list is a list of sales people. The report works perfect for all sales people except one. When I run it...

Hi guys -- brand new to Access -- but making good progress. Trying to NOT use VB to accomplish this (for a variety of reasons). I have a field in our database with five distinct strings, separated by a delimited (a slash or "/"). I've been able to successfully write the formula to parse the...