-- kh

Hi Guys, I have a query looking like that: field1 field2 field3 field4 field5 field6 Data 1 ...

In the query I'm trying to make, I have 7 fields. ContractNumber, CostCode, CostType, EstimatedCost, ActualCost, EstimatedHours, ActualHours. I have...

I am trying to figure out how to dynamically insert results from 20 yes/no checkboxes into a Query. I'm pretty sure it will require VBA and some kind of...

Does anyone know of instructions / utilities that would help me use a select statement from a Crystal report in a MS Access Query? We have several Crystal...

I know this may sound a little paculiar, but I need some help to write a query that will list the record that has the longest entry (textual length - Num...

I need to find a way to create a query that will show a "0" if there is no matching record. The details I have 3 tables with part number & serial number with...

I have a table which contains one field "connector" which could contain one name or more than one name. Is there a way to build a query that will travel...

Hi Guys, I have a query with a field call YNDATA(the one that is a check mark), what I want is to create another field in the query that when YNDATA is true,...

I am having a problem quering two subforms from 3 combo boxesHi, Basically I have a form that contains two sub forms and each sub form has its own individual...

i have 2 fields in a table, 'qty on order' and 'qty rxd', In a query I subtract 'qty rxd' from 'qty on order' how can i store the result of this calculation,...

hello In SQL, is SELECT executed before ORDER BY, or after. Here's why I'm confused about this; Consider table tblEmp with fields EmpID, Name_F,...

I'm having problems with the following formula when I run a query: Sco IIf(=!!,5,IIf(=!!,10,IIf(=!!,20,0))) I'm trying to rate the tickets count like...

Just upgraded to Office 2007. Previous versions automatically sorted queries by name. 2007 groups by query type, then sorts by name. Is there any way to...

Grettings, I am working on a database analysis and need some assistance on building a specific query. I have an input table that was formed at a...

I have several saved exports in Access 2007. Is there a way to run the exports at once without having to go into each one and click run?

Hi, I have an Access database and I'm creating a query in design view. I'd like to bring up a list of all patients who take only aspirin - no other...

PARAMETERS !! Text ( 255 ); SELECT InspectionsDI.ID,InspectionsDI.Area FROM InspectionsDI WHERE InspectionsDI.Area=Forms!!cmbArea; This code works correctly...

So I have the following query ... SELECT Code.CODE, year.yearend, .ACCOUNT, .MINOR, .minor1, .Supplemental, + AS lastytot, year.LYEAR, year.Byear,...

Hi all, i have created a small project in access. 3 database tables. 8 forms, 6 queries. in start up i put the main form to open. and now i unchecked the...