|
|
|
September 12th, 2008 05:23 AM
by david
|
7 |
144 |
|
|
Help in writing SQL statement by
Silvio
I have a query with a cityID field. I am trying to exclude cityID=1 only if
"MyForm OfficeID is = 3".
In short: if Forms!! = 3 then CityID 1 esle all...
|
September 12th, 2008 03:08 AM
by Silvio
|
2 |
80 |
|
|
set field to empty upon condition by
Jean-Paul
I created a continuous form based upon a query
There is a true/false checkbox.
The checkbox is related to a field in a table.
When I check the box I want an...
|
|
5 |
89 |
|
|
change record color on report by
impcmd via AccessMonster.com
On my detail line i have recor that are sorted by date. I would like the
records with todays date to be in read and the other records to stay black.
Is there...
|
September 11th, 2008 10:49 PM
by MGFoster
|
1 |
108 |
|
|
Divide by Zero (Null) by
If
Hello,
I have this code that works
%DDD: Sum(IIF(=0;0;/))
but the second does not
%DDD: Sum(IIF(=0;0;/))
|
September 11th, 2008 10:29 PM
by MGFoster
|
1 |
106 |
|
|
SQL Query by
Erica
Hi I am not a programmer but many years I got a stack sql query off this
discussion group that I used for many projects. I recently left my previous...
|
|
2 |
80 |
|
|
Select Only Newest/Most Current date by
Thorson
I currently have a query-qryIndIDbyDisposition3 set up to show all the
animals that were transferred from one unit to another. Animals are often
Transferred...
|
September 11th, 2008 07:30 PM
by Thorson
|
5 |
104 |
|
|
Unusual Sorting Requirement by
croy
The boss wants to see a "table" with a difficult sorting
pattern.
Where has only two possible values: "WD" or "WE",
and has about 25 possible values, like...
|
|
6 |
82 |
|
|
|
|
4 |
91 |
|
|
|
|
7 |
113 |
|
|
|
September 11th, 2008 04:46 PM
by Jon M.
|
7 |
107 |
|
|
Query changes on its own by
RJF
I created a query that was okay the first time I ran it (Query04).
Then I go run other things in the database, not changing anything, just
running a few...
|
September 11th, 2008 04:28 PM
by RJF
|
2 |
66 |
|
|
GROUP BY question by
0to60[_2_]
Let's say I have an Invoices table setup and I want to find the most recent
invoice date per customer. I'd say:
SELECT Customer, Max(InvoiceDate)
FROM...
|
|
1 |
108 |
|
|
Auto deletion of duplicates by
mrwhitescotland
Hi there.
I have two tables and want to delete duplicates.
ie if they appear in table A and table B then I want BOTH entries to be
deleted and be left with...
|
|
5 |
76 |
|
|
|
|
3 |
94 |
|
|
Key Violation Error by
Chezter
Hi All,
I have an Access table called tblUnits that holds information about each
subject offered by my organisation. In excel, I have a table with the...
|
|
1 |
95 |
|
|
Criteria not working.... by
Sheila D
Hello - I have the following SQL code in my query:
SELECT T_Procedures.Consultant, Q_Procedure_Type_Strings.String,
T_Procedures.Date_Of_Procedure,...
|
September 11th, 2008 01:50 PM
by Sheila D
|
1 |
84 |
|
|
Finding missing records between two tables by
fambaus
Hello Gurus and Friends -
My problem query is this:
I have two tables, A and B, B is a clone of A in structure and data.
To start, the data in A and B match...
|
|
5 |
101 |
|
|
SQL SERVER JOINS CONCEPT: by
venumadhav g[_2_]
Hi Folks,
I am useing SQL Server 2005. I want to join two different tables data from
two different Databases(Ex: 1. Database_X 2. Database_Y). Both...
|
|
3 |
117 |
|
|
Create a 'Make Table' query in 2007 by
Make Table query not creating table
I have created many tables from queries in v.2003. In v.2007 I follow the
directions and am not able to create the table. All the steps work except
when I...
|
|
2 |
98 |