Hi, I'm trying to create a simple query to come up with the difference between two numbers. In the following expression, Limit is a value of 'Number' type in...

I need to creat a totals query that multiplys instead of sums. Can anyone explain how to do this?

I have a user who has a single data table that tracks observations. The fields a CF - what is being observed OD - Observation Date EE - Employee...

Hi, I have a table called "tblOrders", with has following field (example): Order_Num | Created_Date | Customer_ID ...

Hi everyone, I found an older thread that partly answered my...

A simple aggregate Query is Grouping on 4 Fields (one Field uses a Lookup..but I see NO "duplicates" in that). Then I run "sum"s on several Long Integer...

Friends, I have a simple SQL statement in my querybuilder. It goes like this: SELECT operations_code, operations_duration FROM ...

im new to the world of sql, so im not sure if this is can even be accomplished in a single query or if two separate queries are required. i am trying to put...

I have a list of people claiming expenses, many sharing the same payee and I would like to group these records. This works fine with a grouped query, using...

If you are trying to get aggregate information from two tables joined together, and the relationship is one to many, how would you do it? I have found the...

I have got a weird problem, quite possibly the answer is "anything that complicated should be done in SQL Server, not access," but I will ask anyway because I...

I have a table called Observations which has a field called JOBTITLE. In this field we list various types of MDs, RNs, HAs, etc. Most of my reports require...

I want to aggregate date data into weeks of the year. I have checked all date/time function and I can't seem to locate these types of functions. Seems strange...

Hello, are there any aggregating functions in Access that can concatenate (glue together) text?

Hello All, I have table with two fields, Field ID1 can repeat but not ID2. ID2 is unique primary key Both have string data type Table T1 ---------- ID1 ...

I have 25,000+ lines of sanitized medical claims data in an excel file. I have imported into an access table, and can do a lot of what I need, but not...

Count Aggregate Function I have multiple independent queries and I need to get the number of records each of them produced all in one query. I tired union all...

I am trying to make an aging report 30, 30-60, 60-90, 90 days outstanding I have a field which counts the days since the bill was sent Is there a way in...

Here some code for a passthrough query: SELECT f.category, c.FinanceClass, c.ProviderCode, PatDue, PatDueCurrent = Case DateDiff(day, service_date,...

Hello, I am trying to create and unpaid aging invoice report. I have used to forum to obtain several hints and have been able to create a basic aging...