Good afternoon, I'm trying to exclude results returned by a query. I have a field which has the following values: Released, On hold, Maturity A, Maturity B...

I have a combo box form created where the user can select among several options (employee levels or titles). I have a table of records with a checkbox/yes/no...

HEllo.... in the below SQL statement, please advise why i'm getting error: "You TRied to exeute a query that does not include the specified expression...

I hv once done this but I cannot remember how. I want a lookup field with records that are added one by one each time a new value appears. For instance, I...

I am trying to run a Delete Query using two tables. Here is what I have so far: DELETE DISTINCTROW tblProjects., tblComments. FROM tblProjects INNER JOIN...

I am designing a course managment system and need to calculate the tution balances. I have 3 tables Enrollment, Enrollment Details & Payments. An enrollment...

I have a query based on two fields in a table, AmountInStock: - . How do I return this value to the table, tblProducts. Do I need a field in the table...

I am trying to delete records from one table if there are no matching records on a second table. I am getting an error message that tells me to "Specify the...

Hello all I have a lil problem that is racking my brains, Let's say I have multiple zones, within each zone can be a varying number of packages. But these...

hi, I have the following: TRANSFORM Count(Tbl_masterpop.) AS SELECT Tbl_masterpop.status FROM Tbl_masterpop WHERE (( between #7/1/2006# AND #7/31/2006#) ...

i need to show the the corresponding date field that matches the min value of another field. is this possible? thanks for any help.

Hi When I launch a delete query, i always must klikk 3 times yes, yes , yes to get it done. What shall i do to get none ? Thanks for all answers !

In the Northwind application some of the queries such as Alphabetical product list has combo boxes appear for some of the fields in datasheet view, and they...

Hi all! I have a query that pulls information from three different tables. It works great, but I would like it to return only the most recent record for...

I am new to Access so bare with me. I have a table with duplicate records. I need to count the distinct values. I understand 'distinct' will not work in...

Dear all, I’ve built a table named tblProductInfo, in each record, it consists of 1 date field (product_date), 2 numeric fields for product costs of two...

I want to calculate the difference between start time and stop time however my formula datediff("n",) only works if the time does not cross over into a new...

Is it possible to deleted data from certain fields on a particular record, automatically like with a query of some sort? I would use the criteria of course...

Hi, So I downloaded the DH Query By Form mdb from Duane Hookom's library, and I'm having some trouble getting it to work. I've imported everything...

Looking for the best way to do something. Best can be easiest or best practice - I'm up for either. Don't need details (not yet :) - just a general...