Queries

Totals Query
I have a table where I enter the following info Permit# Issue Date Cost State 1234 05/08/08 40.00 WI 1235 05/09/08 40.00 WI How do I set up a query that I can enter a start date and and end date and it will give me the total count of the Permit# and the total costs for WI withi... 27 Jun 2008 14:13

Make table query combining records of two tables into a third tabl
I thought I posted this yesterday, but somehow it did not get into the forum. I apologize if it is there and I just cannot find it, and this is ends up as a dupe. I will be glad to delete it if I can find it. I have tried to simplify my question too. Here is my problem, related to a project I am working on.... 27 Jun 2008 12:09

Time/Date problem
(sorry, I posted this previously in the wrong spot) Good Morning, I searched around and couldn't find another thread with this particular issue so here goes... I have a database where customers get logged in when they come into reception. I have name, phone#, visit#, what they came in for, and an ADATE to log ... 27 Jun 2008 17:18

Syntax for If then Conditional Statement
I'm trying to write a conditional statement in a query that gives me the following: If product ID = 64, 128, or 75, then the renewal rate is 1%. All other product ID's get a renewal rate of 2%. My statement below gives me 1% for all products, and I can't get the syntax right to give me the 2% value for all oth... 27 Jun 2008 16:16

top N per employee
hi, i have a table with lots of rows. I'm trying to pull out the top 10 records by dollar amount by employee. i tried the following: SELECT [employee], [amount] FROM YourTable WHERE amount= (SELECT Top 10 amount FROM YourTable as Temp WHERE Temp.[employee] = YourTable.[employee] ORD... 27 Jun 2008 11:07

Joined table: Returns duplicated record
So, how does he write it so the records do not duplicate? I have to do the same thing and am currently writing seperate queries for each comparison I am doing (answer to a similar question I asked in this community earlier), however when I put these queries together with a union, they duplicate. "Duane Hookom... 27 Jun 2008 11:07

Access Query: get first date field
I am using Access XP. I am working with a database with many file numbers. Each file number has multiple paid dates. How do I get the query to pull each unique file number, and then just the most recent paid date for that file number? ... 26 Jun 2008 21:50

Continuous Form Loading Problem
I have a continuous form that has a combo box based on another field. That is not the problem. The weird thing is that when I am in the form adding data, the values display properly based on their corresponding field. When I close the form and reopen it, only some of the answers are provided even though the d... 29 Jun 2008 16:15

Seniority Ranking by HireDate then LastFour
How do I get a Seniority Ranking # in by query that is already sorted by HireDate then LastFour? ... 26 Jun 2008 18:45

Training schedule -need qry to return all employees for that month
Situation: I have 2 tables: "employee info" & "employee training" linked by "ID" filed. "employee info" has the employee personal information -all I needed for is the name; the "employee training" contains the "training type" (one text field) and 20 "renew training dates" (Date/Time field) including the 1st tim... 26 Jun 2008 19:47