Recent content by AccessExcelHell

Hi, Currently, I have this query in access(where I am using totals, group by, etc), which gives me the totals per LOC ID. But then I need to get totals by Area Name, so I copy into Excel to use the Excel Subtotals function. Is there a way to do the same in access? Region: can have many Area...

I did not expect the answer to be simple, shows you how much I know. Thanks.

Hello, I have a query that gets and computes info from 4 tables. Which get updated each month. The problem that I am having is that, if in any 1 of the tables, the Primary key(location id) does not have a record (for that month), then the query does not give any data for that location. I know...

Sorry, I wasn't clear above. short version of the query: select blah from blah where x=[Enter value]; I have a macro where I use the "Output To" function, which runs this query for me and saves the results in a excel file on my drive. I copied the "Output To" about 15...

Hi, I have a query with 1 field where the criteria value changes. I want to create a macro that runs this query for each possible value of the 1 field. I tried to use the SetValue function prior to running the query but that didn't work. Any ideas? Thanks in Advance.

hindsjl, The iif command i my new best friend. Many thanks.

THWatson, I have a similar question/issue. When you create a CrossTab Query - you can only get 1 field's values - displayed/calculated. So if i want to know the sum of amount, and count of amount per Counrty for example - the CrossTab will only provide 1. ex.. Product Countrty...

Hi, Both of your ideas worked to help me get the data, but now my problem is the format. I tried to use the Access report but could not get it to display properly. I tried to use the crosstab query, but that will only let me put 1 field's values. I can get the data by Month, but can only get...

Hi, I tried it but it only created a field witht he month number for me. I am running Windows 2000 Prof, not XP.

Hello, I need to create a query that will look at data in a table and perform count, sum and avg functions (which i know how to setup) butthen i need this dat per month. I can only get access to do 1 date range. I need help so that i can get the results for each month in the year. Ex. Table...