|
|
SQL query/join syntax by
Spektre
This is actually a MS Access/SQL, but used in conjunction with VB.net
This is a "simple" multitable join question. Some skeleton data to work
with is...
( 1 2 3)
|
|
20 |
415 |
|
|
Does Not IN automatically reduce Count by
Amin
So here is my code:
SELECT "15 Minutes" AS Category, COUNT(*) AS
FROM
WHERE (ENDQUEUE NOT IN("t11arz")
AND (STARTQUEUE IN("Pad", "Paper"))
AND...
|
|
2 |
124 |
|
|
Duplicate Invoice Query by
Newby to Access[_2_]
I am attempting to query a table to filter the invoice field for duplicate
numbers. I am also attempting to filter the payment amount for duplicate...
|
|
1 |
99 |
|
|
Queries by
Newby to Access
Could someone tell me how to write the query that will filter "duplicate
invoice numbers" in a table of 80k+ records and a filter for "same dollar
amounts"...
|
|
2 |
112 |
|
|
Query corresponding to date range. by
maella
Hi and sorry by my grammar mistakes (I'm Spanish)
I've got a table with the following fields:
and I've got another table with the...
( 1 2)
|
|
10 |
230 |
|
|
detecting unwanted characters by
AccessMan
I need a query criterion that returns records in which a text field (255 max
characters) contains any character(s) other than alpha (upper and lower
case),...
|
|
8 |
145 |
|
|
Output Query by
auujxa2 via AccessMonster.com
I have this code in one of my forms, which outputs a crosstab query, and
formats it in Excel. The issue I'm running into, is that It doesn't complete
the...
|
|
0 |
191 |
|
|
skip null value in field when calculating by
Annemarie
I'm trying to calculate the score from survey questions, but don't get an
accurate total if there are null scores. I'm working with over 40,000 surveys
so...
|
|
4 |
122 |
|
|
Calculated field by
Cesar
I'm new using Access, so this may be pretty easy but I can figure outhow to
do it.
I need to calculate a new field (sales commisions) just multiplying the...
( 1 2)
|
|
11 |
189 |
|
|
filter by current month name by
ChuckW
Hi,
I have a table with transactions that has a field called FiscalMonth that
has the name of a month in it (i.e. October). I want to run a query that
will...
|
|
4 |
124 |
|
|
Criteria from form on calculated field by
menube
I have a delivery date field in my query that is calculated. When I type the
criteria directly into the query exp. #10/20/08# everything works fine. If I...
|
October 27th, 2008 08:13 PM
by menube
|
5 |
108 |
|
|
eliminate data subset from query by
Daniel Collison[_2_]
A table includes records related to patient admission episodes. I have
created a query that shows all admission
episodes with a discharge date...
|
|
2 |
99 |
|
|
Rolling Window by
Doc
I need a 7 day rolling window average for each date shown on a query, for
example:
Date range 10/1/2008 - 10/31/2008
Fields:
Daily Average
MTD...
|
October 27th, 2008 06:47 PM
by Doc
|
3 |
104 |
|
|
Parameter query where blank is like "*" by
Dirtbike
I have a form and a paramter query. I want to be able to know that if the
form field is blank just give me all your records.
I tried IIF(Forms!Form1.Vend...
|
|
2 |
95 |
|
|
Update query formula by
bizee
I have data that includes hours per month by job category. In my
months table I also have a column that is the realized hours for each
month. (hours...
|
|
4 |
140 |
|
|
Nested Query Problem by
JimT
I'm trying to create a query with a nested query and I get the dreaded "You
tried to execute a query that does not include the specific expression
FISYEBUD...
|
October 27th, 2008 05:25 PM
by JimT
|
0 |
100 |
|
|
find a date within a range of dates by
Gab
hi i'm trying to find a date within a range and i'm using this expression
IIF( in -60,āYā,āNā)
the creation date should be within invoice date - 60...
|
|
2 |
117 |
|
|
Query Count Question by
DB via AccessMonster.com
I am having a problem with a query and getting the result that I am looking
for. I have 2 fields (a part number and pass/fail combobox).What I want is to
have...
|
|
1 |
88 |
|
|
|
|
3 |
116 |
|
|
Subtotals by
No Name
Hi
I have a query which brings in the following information:
Shop Month SKU Qty
Sample data might be:
AL 12 123 8
BU ...
|
October 27th, 2008 02:00 PM
by No Name
|
4 |
107 |