I sometimes need to pass the results from a multi-select list box to a query, e.g., "Apple" or "Orange" or "Grape" etc. I've done this before by writing a...

Hi I have a stored query in a accdb-database: UPDATE Table SET Field1 = WHERE =; Running the query I am just prompted for one parameter. It must be only...

I will run two "make-table" query with the same criteria I call those two query from a form with DoCmd.OpenQuery the criteria in the query is twice...

I need to update a field in a table I use for grooming data. Something like... IIF (Row1.PO=Row2.PO,Row1.InvNo,Row1.InvNo+1) ....and it would loop through all...

I need to be able to systematically identify any instance where there are overlapping date ranges in a data set. I need to pull records like those listed...

I'm using this function InStr(Trim()," ") on data that looks like this: (USD 65.00) and it is returning a zero. I'm trying to find the first occurance of a...

Hey gang - Access 2003 I have a table that displays the something similar to the...

I have the following query: The sum(taxcredit) is not working -- it is summing all records by PED (period end date) where as I only want it to sum the...

Help! I have been working on this all day and cannot get my head around a solution.... I am running Access 2003. I have created the following select...

I have a query with the following field: DateAdd("d",1-Weekday(),) What is need it to do is calculate all the items between Monday and Friday based on...

I am trying to write a query that returns all records only when all values are 12.0 ? For example, the query below returns the following sample...

I am trying to write a query that returns all records only when all values are 12.0 ? For example, the query below returns the following sample...

I have a query with the following field: DateAdd("d",1-Weekday(),) What is need it to do is calculate all the items between Monday and Friday based on...

I have a query with the following field: DateAdd("d",1-Weekday(),) What is need it to do is calculate all the items between Monday and Friday based on...

I am using Access 2002 and have a two character text field that holds the last to characters of the current year, (example 09). I want to retrieve all the...

I am atempting to use the crosstab query to display a series of data across various dates, but can only get one value field of data to work. Is there a way...

I have the following code in a query: SELECT qryDisciplineLevelAll.EMPLOYEEID, qryDisciplineLevelAll.SSN, qryDisciplineLevelAll.NAME,...

Good Afternoon, I keep getting "You tried to execute a query that does not include the specified expression '(Max(.)) Between . And .' as part of an aggregate...

I need to be able to systematically identify any instance where there are overlapping date ranges in a data set. I need to pull records like those listed...

I need to be able to systematically identify any instance where there are overlapping date ranges in a data set. I need to pull records like those listed...