|
|
Problem with query: SELECT TOP 1 by
ScottA
I'm trying to produce a report that will show when a
machine needs service, which is calculated by evaluating
data in two tables - a service records table and...
|
|
6 |
562 |
|
|
|
|
3 |
154 |
|
|
|
September 2nd, 2004 12:27 PM
by
|
2 |
297 |
|
|
|
September 2nd, 2004 02:32 PM
by StCyrM
|
2 |
182 |
|
|
Dealing with NULL values - NZ function by
Joe Williams
I have two queries - one that totals up labor hours by job number and
another that then uses these totals in calculations.
The problem I am having is that if...
|
|
1 |
258 |
|
|
MULTIPLE 'IF' statements by
Luther
With this statement:
SELECT VariableTable.SectionName,
VariableTable.VariableName,
IF VariableTable.SectionName = "ADS" THEN
VariableTable.TestField = ...
|
September 2nd, 2004 04:20 PM
by LeAnne
|
3 |
169 |
|
|
Look Up in Query Prompt by
Suzanne
I have a table tracking marketing campaigns and I am
developing a query to pull information for one specific
campaign. I added a prompt to the criteria...
|
|
1 |
314 |
|
|
number format by
briank
Is it possible to convert a number format to a text
field. For example, when the user enter the number 56,
the query format changes this to "fifty-six"?
|
|
1 |
398 |
|
|
|
September 2nd, 2004 05:43 PM
by Serg
|
3 |
537 |
|
|
Make table query in a macro by
srs
The macro pauses for the msgboxes when you run a make table query. How do I
answer yes to the questions so that the macro keeps running?
|
|
2 |
137 |
|
|
|
September 2nd, 2004 06:31 PM
by
|
1 |
156 |
|
|
running total # of occurances by
Matt
I have a query with 2 tables. They are order header and
order detail. They are joined by Order Number where Order
number can occur only once in order header...
|
September 2nd, 2004 07:15 PM
by matt
|
2 |
143 |
|
|
Problem with sub query by
Simon Bowyer
Using the query below I am getting a strange result in the sub query on line
7. It returns an integer rather than a yes/no data type when run against an
Access...
|
September 2nd, 2004 08:09 PM
by MGFoster
|
3 |
407 |
|
|
exists sub query by
seeker53
i need to use a sub query with the exists nomenclature. When I try this I
get an odbc failed error. The exists sub query is exists (select svc,
sum(doll) as...
|
September 2nd, 2004 08:33 PM
by MGFoster
|
1 |
256 |
|
|
@@IDENTITY query? by
djc
I saw on a newsgroup somewhere to use the Select @@identiy query to retrieve
the value of the last autonumber ID field added in a table...
I tried SELECT...
( 1 2)
|
|
11 |
321 |
|
|
Autonumber by
PAP
I have created a query with specific data in it. I want
to create an expression (or something) that gives me
an 'autonumber' always starting at 1 and...
|
September 2nd, 2004 10:25 PM
by Tonín
|
2 |
136 |
|
|
Numbers and dates not printing on reports by
Mary
We have an extensive database with information pertaining to incarcerated
individuals. On each form, there are fields with dates and identification
numbers....
|
|
1 |
328 |
|
|
Query Returns Incorrect Results by
Shawn Maida
Hello All,
I am doing some simple calculations on a form and they are not being
generated correctly. Here is an example.
Here is the data:
HistContractPrice...
|
|
2 |
151 |
|
|
Pass-Through Query Headaches by
Galen
I have a date/time called REVDATTIM stored on a remote
table in the following format 7/15/2004 8:05:09 AM.
I have created a pass-through query in access...
|
|
4 |
116 |
|
|
|
|
2 |
334 |