|
|
How to approach complex query by
Julia Boswell
Hi folks,
I'm having a real problem getting a query (or set of queries to work) and no
matter what I try I fail :-( I wonder if someone could help me with...
|
|
5 |
254 |
|
|
If then else statements in sql by
Akilah
I want my query to return a message based on the input received. How do I
make this statement return a message to the same column
(...
|
|
1 |
152 |
|
|
|
|
0 |
124 |
|
|
Help with Query Checking 2 Fields by
Alan
Hi,
I'm hoping that someone will be able to help me with a problem I'm having
with queries.
At the moment I have 3 tables as follows:
Table 1:
ID
MasterList:
|
|
3 |
135 |
|
|
help on query for a report by
Bart
Hi,
Can someone get me started in the right direction. I have 2 tables, one is
production the other is incoming_inventory. In production we have a fields
for...
|
|
6 |
322 |
|
|
Help please! by
jo152
Hi
My query does not work correctly but I really can't see the problem. What I
want to do is to count the number of times T_Details_EnFormation.NIP is
either...
|
|
2 |
108 |
|
|
Left, LTrim, or what by
JWCrosby
I have a field with Lastname, Firstname (ex: "Smith, John")
I want to extract the Last name and first initial (ex: "Smith, J).
What's the code?
Thanks in...
|
|
4 |
169 |
|
|
Add to rows in the same table with query? by
Monsignor JAV
Hello I am relatively new to MS Access 2003 and have a question that is
probably quite simply to answer. I have a a query from a report data
table with the...
|
|
2 |
201 |
|
|
functions in queries by
bindurajeesh
I have created a function and am calling it from a query as an expression.
When I run the query all is fine but when I run the report that uses the
query I am...
|
|
6 |
225 |
|
|
|
|
5 |
230 |
|
|
Combining two IIf expressions into one by
Peter Lawton
I am trying to combine two IIf expressions that work fine by themselves into
a single expression.
I have fields and and two Expressions
a) FinalPub:...
|
|
4 |
201 |
|
|
Count No of orders for customer by
mogens
I have a qry that extracts the open orders, ie orders that have not yet
been processed. The qry is based on table_orders and a...
|
January 22nd, 2006 07:58 PM
by mogens
|
4 |
134 |
|
|
|
|
2 |
123 |
|
|
Calculation by
Sam
Hello All
I need to calculate the average weighted interest rate for a report. I know
how to calculate this manually (using a calculator) however I cannot...
|
|
1 |
112 |
|
|
|
January 22nd, 2006 11:58 AM
by
|
14 |
260 |
|
|
|
|
2 |
185 |
|
|
Help with Date and Time Query by
REA
I hope someone can help me with this;
I am using Access 2003 and I have a date and time field. I would like to
have a query that I enter the date into and it...
|
|
2 |
102 |
|
|
Troublesome query by
RWhittet
Hi, I have built two different queries, one works, and the second does not
work correctly. I am attempting to pull all records from one table, and only
the...
|
|
4 |
445 |
|
|
|
|
4 |
166 |
|
|
Using exist/not exist in subquery by
Damon Heron
I have four containers in my containers table. I want to eliminate the three
that are in my transactions table and just retrieve one. Here is my sql
code that...
|
|
2 |
104 |