I have tried IIf is null, NZ and several other functions. I still get #error in the results of my query. Any ideas? MgrLvl: IIf(! Is...

I've entered the following expression in a query: TotalPay: (*)++ The query doesn't return the resulting calculation. What am I doing wrong? -- Chris

MASTER Table: ClaimsPrimaryKey DETAIL Table: AutoNumberPrimaryKey Date ClaimsPrimaryKey ClaimsStatus This represents, of course, a one-to-many...

Table Account, Field customerid, AccountNo (PK), AccountType(for example: Saving account; Current account, Qdii, etc ) Rule: One customerid may open several...

Hello, I am having some problems with my search panel in Access 03 on XP Pro. I have five fields to allow the user to search for any number (up to )...

I am having some issues with selecting the TOP value in an UPDATE query. I am not an expert and I am looking for advice on the best way to proceed. Here is a...

I'm trying to join two tables via SQL and am getting errors. Any help is appreciated. The tables: taDEFENDANTS DefendantsID PK PropertyID...

This should be simple but I am having a problem. I have a table which I have set up in a left join query against a much larger table. The common field is the...

I used the info in this help article: http://office.microsoft.com/en-us/access/HA010550731033.aspx?pid=CL100570041033 to correct divide by zero errors, and...

If I say 'SELECT TOP 5' and the result set returns less than 5 rows, do I get an error? I looked in Access SQL help and it did not say.

I have the following query (see below). My primary field is TECH_Id (alias CAPId) - and I want to return just one row per CAPId value. However, I have...

I have written a function that executes action parameter queries given a name and a list of parameters. It splits a string into an array, passes the...

I am having trouble figuring out how to show columns and rows in cross tab reports that dont have any data within the table. I am not sure this makes sense but...

Hello, I am trying to build a report based on a query. All the information is in the one table. There are two work programs, and what I need to do is...

I have two tables, tblAcademics and tblScores. Each has an ID column and a date column (Student_ID in both tables, and Assessment_Date and Score_Date for...

Alfie I have just set up my new computer and I am trying it out you are my first port of call. Lets hope I get through ok Harry

I have a report that shows summary information received monthy by locations from policy holders. I would like the information to start with the month of the...

Hi Everyone, Something went wrong with this db, and I'm getting the "VBA file corrupted" message, and "Id is not a valid index" when I attempt to open. I ran...

I'm lost. I would like an unbound text box to pull up a value from another field. so, SELECT FROM WHERE (in the fasting table) = (from this table) AND ...

Hello. There are a lot of duplicate records in a table. I used the duplicate wizard to find them. I also have a checkbox named "dupli". What I need is to...