Query for two fields
Wed, 17 Dec 2008 06:41:39 -0800
In a table are fields QtyYear & QtyAmount. QtyYear contains the year (2007,
2008) for the donated amount (QtyAmount). But if no donation for that year
then no record.
I wanted to pull donors who gave in both 2007 & 2008. Not including folks
who gave in just one of those years. I've tried:
SELECT D.Donor
FRO ...
|
Where did my criteria table go in query design?
Wed, 17 Dec 2008 06:33:29 -0800 (PST)
I created a new query and all was OK: tables and joins in top of
design window.
Table showing fields to display and criteria in bottom of same query
design window.
When I returned later to the saved query, I bottom table is nowhere to
be found.
I scroll down and scroll to right and can?t find the table (my
...
|
Query to update column in original table
Wed, 17 Dec 2008 02:03:01 -0800
Is there anyway to write a query to update details in the original table to
fill out a blank column.
For example:
If the value in "Properties" column = 4 then cells in the "Name" column will
= Camera.
If the value in "Properties" column = 6 then cells in the "Name" column will
= Batteries ...
|
.adp Query with a function?
Tue, 16 Dec 2008 17:36:00 -0800
Hi,
I am working with an access data project from a SQL 2005 database. I have a
query that pulls two different letter grades for a student and then using a
link to another table, I insert a coulmn with a numeric value for the letter
grades. I would also like a column that will calculate the difference
bet ...
|
Tricky text sorting !
Tue, 16 Dec 2008 16:03:01 -0800
Hi !
Got a field that may contain 1 or 2 or 3 letters or none.
The letters are V A P
Recordset may look like this:
v
ap
va
(nothing)
p
vp
vpa
a
va
I'd like to be able to make a query that sort all field that contain the
letter a
Merci !
JF Grenier
...
|
How to add sum from Query to Table
Tue, 16 Dec 2008 15:04:01 -0800
Proposed Total: [Proposed Amount 1]+[Proposed Amount 2]+[Proposed Amount
3]+[Proposed Amount 4]
In query design view I have the Proposed Total field sum of 4 other fields.
So, on the Form I enter figures in any of the Proposed Amount fields and they
sum in the Proposed Total field on the form. The problem ...
|
Delete records based on multiple criteria
Tue, 16 Dec 2008 14:27:49 -0800
For the records shown below, I need to delete the records where a person is
in "travel mode" (ExpCat = "Travel Costs") has meals (ExpType="Meals-Travel")
on the SAME day (ExpDate) as his lodging (ExpType="Lodging"). In this
example, the meals on 10/8 would be deleted, but not the meals on 10/6 and
10/7 becau ...
|
|
|
Pivot Table Query add Formula columns
Tue, 16 Dec 2008 11:01:29 -0800 (PST)
Hello,
I have created my pivot table with this MS Access query ,
transform max(value)
select hour from mytable group by label
pivot label
below is the Table output from pivot table query :
Hour A B C
1 15 14 21
2 22 23 24
3 21 33 11
4 10 10 10
I woul ...
|
Select Max and Next to Max Dates
Tue, 16 Dec 2008 10:16:04 -0800
I am writing a query that pulls the most recent month start date and the
month before the most recent (eg. #10/1/2008# and #11/1/2008#)
Currently I write to subqueries in the criteria line:
CDate(Month((SELECT MAX(dtmMonthStart) FROM tInventory))-1 & "/1/" &
Year((SELECT MAX(dtmMonthStart) FROM tInventory))) ...
|
sum columns
Tue, 16 Dec 2008 09:43:01 -0800
I need to display days of the week in a subform and hours worked per day. I
then need to total the hours and perform calculations on the total, which I
also need to display. After trawling through these posts I concluded that the
best way would be to have each day as a field and the hours as a row. I then
cr ...
|
