|
|
Query modification by
CurtH
I have the current query which works:
Dental Status: IIf( ="9","90 Days or Before DentalDue
Notification",IIf(="12","Annual Dental Exam...
|
|
3 |
218 |
|
|
Query to look up value from other field by
Diggsy
Hello,
I am currently working on a query that looks up a specific field based on my
hardcoded input. I have 52 fields in a table named Forecasts The fields...
|
|
1 |
124 |
|
|
Nested IIF by
scubadiver
Hi folks!
I have a currency field in a query (called "ave1") and I want to create a
classification field based on the following so the new field should...
|
|
6 |
173 |
|
|
Embedded Image (sizing) by
stephanie
Hello. I have a form with an embedded picture. All is well. But I'm curious
how to best size the embedded picture frame so that downloads from a digital...
|
|
1 |
120 |
|
|
Attaching picture (sizing) by
stephanie
Hello. I have a form with an embedded picture. All is well. But I'm curious
how to best size the picture so that downloads from a digital camera will
fit. ...
|
|
1 |
150 |
|
|
|
February 13th, 2007 04:21 PM
by Iowa Joe
|
1 |
142 |
|
|
UTC Time zone and Now() function by
Tech Geek 1234
I have a database in which all date and time fields will be entered in UTC
time. I need a query to give me records from the past 30 days. I am
currently...
|
|
1 |
147 |
|
|
Crosstab Query by
MPM1100
I would like to enhance a crosstab query I am working with.
First, I have a tabe of transactions. Each transaction has a date, a trans
type, and an amount....
|
February 13th, 2007 03:07 PM
by MPM1100
|
0 |
176 |
|
|
Insert Into syntax help by
XP
Using Office 2003 and Windows XP;
Can someone please help me clear the syntax error I'm getting from this SQL?:
INSERT INTO
Table1 AS A
SELECT...
|
February 13th, 2007 01:50 PM
by XP
|
2 |
156 |
|
|
Delete Query by
CoachBarkerOJPW
Let's try this.
I have a registration data base for a youth sport program (thanks to a lot
of useful advice from the people in here). A youth can be enrolled...
|
|
5 |
165 |
|
|
Relationships by
Matt Dawson
Is it possible to create a like relationship?
I have two tables but one contains variations on the other ie setup per
machine and are called different...
( 1 2)
|
|
11 |
213 |
|
|
Broken Query (can't open or edit) by
Engels
I have a Select query which is acting realy strange.
it'll run through a form and it'll print straight from the Database Window
It wont however either open...
|
February 13th, 2007 12:06 PM
by Engels
|
1 |
151 |
|
|
criteria from form not working by
franklinbukoski
The following is a sql view of my query:
SELECT Subtopics.Subtopics
FROM INNER JOIN Subtopics ON . =
Subtopics.
WHERE (((.Topic)=!!));
when I click on an...
|
|
3 |
147 |
|
|
Access to access via Net by
Matti Koski
Hi,
I would like to study of how to make an easy user interface via Net to
Access database. Please give your recommendation.
Matti
|
|
0 |
115 |
|
|
|
|
4 |
175 |
|
|
GETTING THE MOST RECENT DATE by
bifteki via AccessMonster.com
There's a table called tbl_contacts and each contact is related to a company
from the table tbl_companies. I want to get the most recent contact from...
|
|
6 |
179 |
|
|
Showing Crosstab Totals Column in Chart by
ALEX
I have the following crosstab query. I'd like to be able to put the Total Of
Amount on the secondary axis, but I can't figure out how. I appreciate your...
|
|
1 |
116 |
|
|
|
|
4 |
122 |
|
|
grouping by
Joel Allen
Hello,
I have a table with fields like this:
Store location, quanity of red apples, quantity of green apples.
e.g.
Redmond,26,40
|
|
3 |
149 |
|
|
|
|
1 |
172 |