|
|
IF statement by
Florida Analyst
I'm not the best with SQL for Access however I want to create an IF THEN
Scenario, this is how I would write it in the SQL I know (I mostly use SAS):
(CASE...
|
|
7 |
176 |
|
|
|
|
3 |
175 |
|
|
Formulas by
Devan
I need alot of help. I am new to the access software and I am trying to
create a database. I need a formula from excel to work in access....
|
|
8 |
212 |
|
|
Query as data source for form by
News Boy
I have data in 3 tables called Carriers, Routes, and Subs. I can make a form
display data from one table at a time. But, to access multiple tables, a
query...
( 1 2)
|
|
11 |
374 |
|
|
using the Or criteria by
Barbara
I have a query that in addition to the name and address fields has 4 fields
named using iif statements. I need criteria to select names based on a "Yes"...
|
July 8th, 2008 07:28 PM
by Klatuu
|
2 |
164 |
|
|
|
July 8th, 2008 07:22 PM
by Ryan
|
4 |
310 |
|
|
Stuck on a date issue by
Sue
Hi all, and thanks in advance.
I have dates entered in mm/dd/yyyy format but want to sort disregarding the
year... in other words, the following fields would...
|
July 8th, 2008 07:17 PM
by Ryan
|
7 |
208 |
|
|
Union Query to a Table by
miss_mas
I created a union query. How do I get the output to go to a new table?
Do I have to CREATE TABLE then use all the INSERT INTO functions or is there
an easier...
|
|
3 |
173 |
|
|
Using DLOOKUP with totals (aggregate) queries? by
Dominic Greco via AccessMonster.com
I have an totals/aggregate query that looks at a table and returns the total
estimated structural engineering hours. I need to convert that SQL code to...
|
|
2 |
454 |
|
|
Next item in line by
OEB
I am not sure how to really explain this, but here is what I need. I have a
list of items that are in chronological order listing the stages a project
goes...
|
|
3 |
267 |
|
|
|
|
1 |
189 |
|
|
Duplicate values by
Nuno Gomes
Hello, all
I have a table that have +/- 40000 records of duplicate entries.
I know i need the record more recent of the duplicates (i have the field
DATA_V...
|
|
2 |
150 |
|
|
|
|
1 |
207 |
|
|
filtering in queries by
NES
I have a table with a field that is to be formatted as "99999-9999-999" where
the N stands for a digit: 5 digits, dash, 4 digits, dash 3 digits.
I have...
|
|
3 |
168 |
|
|
SQL WHERE = Query Results by
auujxa2 via AccessMonster.com
This is in conjunction with my previous thread. I'll try and simplify my
request.
How do I write this SQL:
" WHERE = .... The values from !?
Thank you in...
|
|
6 |
175 |
|
|
Nested IIf: Define ranges, = And =? by
CanonMaiden
I'm trying to create a commission rate by defining several ranges based on
the Sale_Price field's value.
I am creating a calculated field in a query with the...
|
|
2 |
132 |
|
|
|
|
0 |
131 |
|
|
Left Join Question by
Grace
I use Access 2003 and a database with the following tables
Table named Employees with the following fields: Payroll ID (this is not an
AutoNumber field),...
|
July 8th, 2008 03:26 AM
by Grace
|
2 |
148 |
|
|
Limiting A Query by Using a text format by
Brad[_6_]
All,
I have a License_Text_ ID field with several different types of license
formats.
I would like to limit a query to only returning IDs with a format of...
|
|
2 |
132 |
|
|
No Value returning from query by
Brennan
I have a query that sums a particular field as part of the query. Sometimes
there is not any data to sum and so no value is returned in the sum line. Is...
|
|
3 |
161 |