Search results

Can Someone help me with this? I don't know how to use the Where clause correctly and I am not very good with SQL either. I Just need to be able to pull a date range from two date fields with and 'either, or' type of mentality.

I keep putting that in as an expression but it keeps disappearing when i click on another cell. I also tried putting it as a Where and it did the same thing. Am i doing something wrong?

Hi, So I have two date fields that i need to pull information from. I do not need duplicate data. However i can not figure out how to set up the expression. I need date1 to show up if it falls in this 1/31/2010 - 3/31/2010 If date2's date falls within 1/31/201 -3/31/2010 then i need it to show...

Bob- Thank you for helping with this. It was driving me crazy and I still a novice with Access.

So it all works... but is there no way for the row to group into one line and sum the entire balances? Thanks for all your help Bob Larson.

Everything else works except for the last expression. After it is typed it came up with this error. that there was an extra comma without a preceding value or identifer.

Thank you so much that worked like a charm. Now that I have that set up, do you know i could possibly group the returned value? and have it also sum the balance for each group?

Hello So I have created an IIF Statement that states: Description3: IIf([State]="UT" And [Balance]>=1000000,[Description],"Other-In Utah") The statement works fine. The problem is I need to field to return if the data is above 1000000 and within Utah I need the Table Description to show. If...

So my query is set up as so. Broker_Descrp (Table Field) Balance (Sum of a Table Field) Tier 1 % (Expression) Description (Expression - IIF Statement) Well my Description expression basically is showing the actual broker description of the balance is over 1,000,000 but if it is below it...

The problem with using it in a report, when I make slight changes to the report, often it screws with my query and i have to recreate the query field and report over again. Also i want an actual field in the query for when i am creating charts. The Bar chart in Access does not allow for percents...

I apologize for that... I did not mean to refer to the field as a column. i understand how to sum a group, but i want to create a field on the query for percent of each group in relationship to the entire query. You can accomplish this through a report, but I would like it as a percent in the...

Is there a way to take the column total and have it display for each group in a query?

Smeghead, Thank you soooo Much... worked like a charm.

Ok, understood and implemented... However, It shows all the sales people, but I am trying to exclude the ones that are equal to the query. So only show sales people with no deals.

Do I need a full outer join? Could i use just a right or left outer join? Also is there an easier way to accomplish this without an outer join?, I only need one field to show up.

Is there a select Inverse function in MS Access? I have a query that generates a list of sales people, some of the sales people do not show up on the list because they do not have any current deals. I want a function or query of some sort that will connect the the original query and generate...

Thanks Dan, I figured it out. I didn't have the IIF statement set up as an expression, it had grouped by in the Total category. That fixed the issue.

Yes [Description] is an actual field in the query it actually comes from one of my tables.

So I have a query I have created that has terms and a balance connected to each row of data. I wanted to know the total for each category, therefore I created and aggregate function and named it balance. Then I needed to limit all balances lower than 1,000,000 and have them combined into one...