|
|
even and odd numbers by
Mansoor
How should I write the following:
IIf( is even,0,1)
Thanks in advance mansoor
|
February 13th, 2010 10:44 PM
by Mansoor
|
7 |
261 |
|
|
ranking players in a competition by
JOSELUIS
HI MY NAME IS JOSE LUIS FROM SPAIN I´M A ROCKIE IN ACCESS.I CREATE A ACCESS
DATABASE FOR A SPORT COMPETITION. IN A QUERY I CREATE...
|
|
5 |
172 |
|
|
ranking players in a competition by
JOSELUIS
HI MY NAME IS JOSE LUIS FROM SPAIN I´M A ROCKIE IN ACCESS.I CREATE A ACCESS
DATABASE FOR A SPORT COMPETITION.
IN A QUERY I CREATE...
|
|
6 |
186 |
|
|
HOW 2 MAKE AN ALIAS? by
Faraz A. Qureshi
I have a crosstab query as follows:
TRANSFORM Sum(NwTbl.AMT) AS SUMAMOUNT
SELECT NwTbl.ACC, NwTbl.DT
FROM (SELECT DT, DR AS ACC, AMT, "CR" AS AMOUNT FROM...
|
|
2 |
266 |
|
|
Need Help with Geographical Sort by
Dana F. Brewer[_2_]
Hi, and thanks! I have a table of thousands of names and addresses that I
have to make turn by turn maps from. I am using Access to manage the data
and...
|
|
4 |
235 |
|
|
Query return duplicate results by
Bill.Carlson
Access 2007
we are a small cpa firm processing Quicken information for a client
we have a table, tblTrnsctnQkn comprising Quicken transactions (Date,
ckNmbr,...
|
|
1 |
157 |
|
|
Need help with changing query by
Afrosheen via AccessMonster.com
First of all, thanks for reading this.
Here's my problem. I have 1 field called and another called . At
one time the word sex was a text field Male or...
|
|
4 |
307 |
|
|
Not sure why! by
PeterM
I have a table:
Pain diary
PD_Date
PD_Med_1_Name
PD_Med_1_Dosage
PD_Med_2_Name
PD_Med_2_Dosage
PD_Med_3_Name
PD_Med_3_Dosage
PD_Med_4_Name
|
|
4 |
163 |
|
|
|
February 12th, 2010 10:48 PM
by Steve_A
|
4 |
148 |
|
|
|
|
1 |
151 |
|
|
Update query with autonumber field by
Microsoft Access
I have setup my table so that the invoiceID would autonumber. The issue I am
trying to figure out is what to do when I want to update a row. I figure
there...
|
|
4 |
213 |
|
|
|
|
3 |
194 |
|
|
|
|
3 |
158 |
|
|
|
February 12th, 2010 05:34 PM
by Andi
|
2 |
168 |
|
|
too many fields defined by
Jeff Kaufman[_2_]
I am getting a too many fields defined error when attempting to add 5
different queries into 1... what is happening?
|
|
2 |
218 |
|
|
|
|
0 |
190 |
|
|
Multiple Commas by
mdkryptoking
I have a name field and it has multiple commas in it:
last name, first name,
i am trying to split it out into two different columns but the second comma
is...
|
|
0 |
160 |
|
|
Multi User Application by
Pankaj Michael
Hi to all,
I am new to access develop applications.
I created application for multi user idea I want my application can be
accessed by multi users. So I want...
|
|
1 |
128 |
|
|
Non-Recognition of a parameter by
Faraz A. Qureshi
In my following query !! is indicated to be not
recognized while the same had been selected via expression builder. Any idea?
SELECT Fltr.ACC, Fltr.DT,...
|
|
1 |
151 |
|
|
Averages problem by
KevinE via AccessMonster.com
Hello,
I'm trying to do a simple average query as set out below:
SELECT .Names, Avg(.Hrs) AS AvgOfHrs, Count(.Hrs) AS
CountOfHrs
FROM
GROUP BY .Names,...
|
|
2 |
139 |