|
|
My criteria doesn't work. by
Lydia
Hi,
What is wrong with both of following criteria:
This one, Access tells me "The expression is to complex..."
iif(forms!frmProduct!cmbPL="Totals", Is Null ,...
|
July 1st, 2008 04:55 PM
by Lydia
|
7 |
204 |
|
|
|
|
1 |
171 |
|
|
parameter query by
[email protected]
I know how to create a parameter query. What I'd like to do is run a
parameter query that displays many child records of one parent record
that permits...
( 1 2)
|
|
13 |
308 |
|
|
Easy query criteria question by
Bongard
For some reason I can't figure this out. I have two fields in my query
(relevant for this question). (numeric field) and
(text). I need my criteria to say...
|
|
3 |
169 |
|
|
using query returns to create new columns by
TaniaD
Hi,
I'm working on a project that requires something I'm sure can be
accomplished with SQL, but I can't figure it out myself. Basically I have a
list of...
|
|
8 |
231 |
|
|
Print Query Expressions by
Regi
I'd like to print the expressions I have set up in a query. I know I can do
it via print screen and I can get the SQL view through Access Document veiwer
but...
|
July 1st, 2008 01:43 PM
by Regi
|
0 |
134 |
|
|
delete duplicates by
Darren
I have one table (table 1) with a column A & B and another table (table 2)
with columns C & D. Now there are duplicates in table 2 on the values in
column C....
|
|
1 |
158 |
|
|
Different results in SQL and Access by
Pat Backowski
Hi Everyone,
When I run the query
Select a,b,c from mytable where trandate = #20/06/2008 00:00:01# and
trandate = #20/06/2008 23:59:59# and (trantype =...
( 1 2)
|
|
17 |
531 |
|
|
Queries without duplicates by
puppypaws
I'm working with a huge imported database from which I needa query with
employee id, last name, first name, benefit name employee cost and employer
cost. I...
|
|
5 |
191 |
|
|
|
|
2 |
178 |
|
|
|
|
3 |
170 |
|
|
Query with IF statements and lookups by
MichaelR
Hi,
I'm trying to write a query and I'm not sure if it's even possible.
I have two tables - one with sales data for the whole company and the other
with...
|
|
2 |
164 |
|
|
One Command Button for different reports by
Francis Cunningham, Jr.
I am not sure if I am in the right Discussion Group, so here it is...
I have five different queries called ‘Cooling, Electric, Gas, Heat Pump and
Oil’
I...
|
|
1 |
156 |
|
|
Group By Qtr by
acss
I cant figure out how to group my records by quarters or months.Is there a
special query to otain these results? My current SQL is pretty basic using
two...
|
|
2 |
163 |
|
|
DSUM Syntax Error by
NeoFax
I am getting the following suntax error: "Syntax error in string in
query expression '=6'""(second quote is not in the error
screen). Here is my DSum...
|
June 30th, 2008 08:49 PM
by NeoFax
|
1 |
146 |
|
|
Average Records between date range by
Love Buzz
Hi all.
I am trying to average the total records by date range. I am getting an
error message with my AVG expression. Here is a snap shot of the SQL I have...
( 1 2)
|
|
12 |
385 |
|
|
SQL Statement by
Joe Gonzalez
I have a table of just months and years for example:
2008-01
2008-02
2008-03
2008-04
2008-05
2008-06
And I have another table that is storing data that...
|
|
2 |
170 |
|
|
|
|
3 |
141 |
|
|
Using SELECT DISTINCT by
Leslie Isaacs[_2_]
Hello All
I have a table , and 2 of the fields are 'practice' and 'month
name'. This table contains typically between 10 and 50 records for each
combination...
|
|
9 |
183 |
|
|
Duplicating values to empty field by
DanBakerUSAF
I am new to SQL in queries. I can ussually get what I want with forms and
the query wizard. This I cannot figure out and it seems like a SQL statement...
|
|
6 |
168 |