Help! I can not solve this. Must be SQL, as I connect through Jet. Pmts not fully Applied (such as clients who prepay), must be accounted for. Database...

Ok I am trying to generate a query using 3 other queries. I'm having success so far except for 1 problem. The "Briquetting Rate Query" looks fine on its own,...

I need to write a query that counts number of unique occurences of a combination of 3 fields in the same table (Inventory): PC Brand, Operating System, and...

im doing something i thought was very simple. i have 4 fields in my select query. the year field which is set to group by, Loan amount set to count, race...

I read a lot of responses and I'm not seeing what I'm looking for. I would like to build a query to count how many times a certain name is included in the...

I have a query with two fields; a PC ID number, and the date it last backed up. I want the query to return any PC that hasn't backed up in the past 7 days. ...

I am trying to find the total number of bank accounts for each month. The table I am working with has a card number and a transaction date. I group by card...

I have a table with several "ref" values for a given "SH". I would like to find the min and max ref per sh. I have: Select sh,MAX(rm) as Maxrm, MIN(rm) as...

Hello; I have two tables Table 1 Rx ------- RxNumber, RxId(no duplicates), RxDate, Name, Notes, Type, DOB Table 2 Email -------

I am having the worst time with a simple task. I have a field of numbers in a table. That look like this: 94900 212252 212143 I want to convert them to...

How do I: 1) Group a list of transactions by Item#. There are multiple Item# with several transactions. Group_by??? 2) Select the earliest date for each...

This may be a dublicate but I don't think my last question got posted: I am trying to find out how to run an update query automatically. I have a table of...

I have a query that uses another query's output as its source. The first query has a parameter entered by the user. Whenever I run the query, the parameter...

I am trying to chart (preferably Pivot Chart) a DSum query showing the cumulative sum by sample date. The SQL for my query is as follows: SELECT...

I do not have any problems getting the function to give me a text answer but I need something like this IIf(140, /2, ). This was obviously not working. If...

I have a number field that contains numbers from 555555 to 199999999. I need to convert the data to a 9 character text field with leading zeros. Numbers with...

alright i have a invoice form that uses a subform to select products. it looks up the ID for each product and is bound to a table called suborders. it also...

how do i create a crosstab query in an ADP application so that I can create a graph from the data? the query im trying to enter is: TRANSFORM Sum(Clients) AS...

Hi, In this instruction INSERT INTO MyTable ( date1, date2 ) SELECT #27/07/2005# AS Expr1, #08/02/2005# AS Expr2; The date2 appears changed, I mind the day...

I've got a union query that we use to generate an internal email list. See below. To accommodate people requesting to be taken off, I'm trying to figure out a...