DSum in Query
Mon, 25 Aug 2008 18:53:00 -0700
I am trying to create a calculated expression in a query to sum the total
weeks service each individual has worked in their current department. For
example an employee works 52 weeks in Sales, 52 weeks in Purchasing and then
returns to Sales where he is currently working and has been there 104 weeks.
I wan ...
|
Calculated field - Min of several columns
Mon, 25 Aug 2008 18:44:25 -0700 (PDT)
I am building a line capacity table for a can routing in a factory.
Several machines, each as a line capacity in a column - one column one
machine.
How do I find the minimum of the line capacities of one set of machine
across the seveal columns?
I tried DMin but that did not seem to work.
Can I write a ...
|
Update table based upon join
Mon, 25 Aug 2008 15:18:15 -0700
Thank you all for looking, I very much appreciate any suggestions. I have a
database that is has a summary table that has a collection of data about
Telephones and their service (i.e. ID, make, model, location, responsible
party, classification and comments). Basically what I need to do is run an
update qu ...
|
Query end of month data
Mon, 25 Aug 2008 13:50:13 -0700
Hello all!
I'm trying to write a make table query using the table "Portfolio" to pull
out only the end of month data. For example, the Portfolio table is set up
something like this:
Date | Security | Amt
7/31/08 | A | 10
7/31/08 | B | 20
7/31/08 | C | 30
.
.
.
8/28/08 | A | 10
8/28/08 | B | 20
8/ ...
|
Date query problem
Mon, 25 Aug 2008 23:47:16 +0300
Hi,
I have access database with date column and number of rows with same date
but with different time,
I'm trying to view names from database that has the month of today date,
My query is:
SELECT Table1.*
FROM Table1
WHERE (((Table1.name)='myname') AND ((Year(Date()))=Year([Table1].[Date1]))
AND ((Month( ...
|
>=(Now()-1)
Mon, 25 Aug 2008 13:44:07 -0700
What does this mean in criteria for date? Thanks ...
|
top 20 records by group
Mon, 25 Aug 2008 13:12:09 -0700
Need to select top 20 records by location based on the sum of balances. Here
is what I have so far, but it is only giving me the top 20 of all not of each
location; your suggestion is welcome.
Thank you
SELECT TOP 20 account.ProfCtr, account.Own1SSN, account.Own1Name,
Sum(([currentBal])) AS [Total Bala ...
|
|
|
Query Question to Lookup
Mon, 25 Aug 2008 12:14:17 -0700
I have a two table one that has users listed as test, john in one cell and I
have a list the just list the last name. I was wondering how can I setup a
query that is the last name is in table one that it only looks at test, and
after the comma stops looking? Any ideas?
Thanks, Anthony ...
|
Find records not linked
Mon, 25 Aug 2008 09:43:08 -0700 (PDT)
Hi,
I would like to create a query which only shows records that are not
are linked. In this example I have a host table, a student table and
a table to link students to the host. Basically I would like to show
all the students who have not been linked to a host.
Any suggestions? ...
|
Need SQL expert!
Mon, 25 Aug 2008 16:23:51 GMT
I have SQL that I am trying to put into the SQL view of an access query, that
is not working. At a glance, can you scan this and tell me what you think is
wrong? I know you have to write a certain syntax for SQL using VBA, but I
didn't know I did for SQL view in access queries.
Thank you in advance. (p.s. ...
|
