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'm using Access 2003. I am a new user who si trying to build an expression for this query: Whose membership expires next month?? So far I have: ! How do I...

I have a table which contains sequential dates that are one day apart from each other, in order to see entries for the last five days, I have used...

Is there a way to calculate between work dates? For example: Application Date is 10/01/2007 If I want to calculate a Follow-up Date 5 business days after...

I have the following expression for a total of a field has has 90 records with each having a figure of 29.50 in them. I want to total this field and the...

I am having difficulty designing a query and would like some help. The query should return only ONE row per SalesOrder. The query should SUM the...

Hi all I have a sum in a report as follows :- Control Source=Sum() Running Sum = Over Group My question is how can I transfer this to a query

I've got the following function in my database, taken from another thread on here. It is used to calculate the number of days in a date range, the date...

Hi all, I am pretty well stumped on this one and it is hard for me to explain sooo here is my data: PN: Test to...

I have a form that has a cmd button when pressed it request a parm and than run a union query and displays the results in a subform on the main form. The...

Hi all, I would like to create a querie whereby i have dates of orders raised and need to calculate from this month less 4 months. In other words i need to...

I have a query with several fields that I need to pull out certain information from. The fields are all expiration dates for various items. I need to show...

Is it possible to define the jolly character '*' (star) as a query field's criteria at run time? How?

I am trying to right a query that compares 2 different records based on 2 diff. fields all in the same table. ex. column 1 Column2 22334 ...

I have 3 tables Table_A, Table_B, Table_C. Each month I need to compare tables A & B and copy the differences to table C and update 2 fields on table C, one...

Hello, you were kind enough to answer my question regarding date criteria in queries using data from a works database where there are several dates in the...

I am trying to create an expression in a query that says if CONTRIBUTION BEGIN year is less then 2006 and the AUTE2 = 00/00/00 then count the number of "0" in...

Hello All, I am at a loss why I can't get a simple price. Public Function ServiceZone(Mileage) As Currency 'created 8.22.2007 Dim Crit Crit = "( =...

I receive an error of specified field could refer to more than one table listed in the from clause of your sql statement. Here is my...

I think I read somewhere that using an "IN SELECT..." type of query will speed up your query performance in Access 2003 better than linking the two tables by...