Cannot quit out of query - forces save
Thu, 4 Sep 2008 09:30:01 -0700
I've poked around help and the newsgroup trying to figure out what I did but
I can't find the answer. All of a sudden today, I cannot modify a query and
then abort the changes. Access is forcing me to save every new query.
Changes to existing queries are saved automatically.
I know I must've changed some ...
|
Simple Queury question
Thu, 4 Sep 2008 09:23:01 -0700
Hi all.
I am trying to count two columns using two variables 11 and "R". I keep
getting "This expression is typed incorrectly, or it is too complex to be
evaluated".
Thanks for your help.
SELECT [ANF Analysis].[Rej Date], [ANF Analysis].Queu, [ANF
Analysis].Operator, Count([ANF Analysis].Disp) AS Cou ...
|
2 nested select queries
Thu, 04 Sep 2008 15:00:57 GMT
Is it possible to have 2 nested select queries in a select query?
I currently have the following query:
SELECT 1.a,2.b,3.c FROM 1,2,3 WHERE 2.b IN (SELECT 2.b FROM 2 WHERE 2.b_ID =
1.b_ID)
The above statement works well in retrieving the value for 2.b, but now I'm
trying to add a second nested select sta ...
|
How to set a "Gate" in access query
Thu, 4 Sep 2008 07:56:00 -0700
Here is my situation:
I am creating a database to calculate commissions for salespeople. Each
salesperson gets 4% commission until they reach what is called a gate (a
fixed amount). Once their commission has reached this gate amount, they get
8% of everything over the gate amount. I have tables called salespe ...
|
Most recent update query
Thu, 04 Sep 2008 07:52:02 -0700
I have a database where table A stores issues, and table B stores all the updates to those issues. Table B also has the pk from table A to maintain the connection. Table A and B have autonumbers for their pk.
I am trying to build a query that will only pull the most recent update from table B for every issue in ...
|
Date Question
Thu, 4 Sep 2008 07:50:01 -0700
Hello everyone,
I have a database that has two fields that are used in order for a record to
be complete. The are DateSatRsp (Date of Satisfactory Response) and
DateUnsatRsp (Date of Unsatisfactory Response). When the user enters the
record is complete code is generated to make sure a date is enter is at ...
|
Field Name in Cross Tab Query
Thu, 4 Sep 2008 07:49:02 -0700
I have a query as follows:
TRANSFORM Sum(tblSales.amount) AS SumOfamount
SELECT lessee.lessee
FROM (lessee INNER JOIN (gamemaster INNER JOIN tblSales ON (gamemaster.game
= tblSales.game) AND (gamemaster.game = tblSales.game)) ON lessee.lessee =
gamemaster.lessee) INNER JOIN tblControlFile ON tblSales.fairda ...
|
|
|
Min function
Thu, 4 Sep 2008 09:37:19 -0500
Hi there,
I want to use a function that finds a minimum between a list of number in
query.
I don't know what this function is, so I will call it "Func"
For example, in one column in query design view I would like to write
something like this:
Minimum: Func(4,5,6,2,9)
Then when I run th ...
|
New user question - timesheet query
Thu, 4 Sep 2008 07:24:33 -0700
I have been inputting employee timesheet data into a table for the last 3
months.
I have been able to write a query to give the total hours worked in this
time, but I am struggling to develop a query to give me the average hours
worked for each employee over the last rolling 12 weeks.
Please help but keep it ...
|
Renaming field names of Linked Table in query
Thu, 04 Sep 2008 06:53:40 -0700
Have you considered using a make table query? You can take the field names and change them in the query. In the query you set the name you want to display and the table and field you are taking it from New name:[table]![field] You can also right click and use the build function
...
|
