How should I write the following: IIf( is even,0,1) Thanks in advance mansoor

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...

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...

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...

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...

Access 2007 we are a small cpa firm processing Quicken information for a client we have a table, tblTrnsctnQkn comprising Quicken transactions (Date, ckNmbr,...

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...

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

I am trying to show all lines of Sheet1.ER_NUMBER and all partial matches of AUTHDOR.Field24 I am trying to use this SELECT Sheet1.ER_NUMBER, ...

Hi All, looking for some advice. I have an HR table that contains employee information but does not contain management chain info. Basically i am trying to...

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...

I have a database which has worked well for a long time, until a recent change request. Now this change has identified a flaw in the original coding logic,...

I am trying to insert a comma between and field if the field is not null - but I don't want the comma if the field is null RPTNAME: IIf(=" ",,IIf(" ",...

I have an Employee review table that I need to query. The table is set so each employee can have up to 10 reviews by 10 different reviewers. Reviews will be...

I am getting a too many fields defined error when attempting to add 5 different queries into 1... what is happening?

Can someone provide info in how to show pivot charts from a query in more than one page. When choosing the option to display them all, Access places them...

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...

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...

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,...

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,...