I have a table with the following fields: , , . There are about 10 JobNumbers with about several hundred Tasks each. I would like to write a query that returns...

Well here I go again. Biting off more than my brain can handle. I have a report that shows all of our machines in our plant. I’m tracking both machine down...

I want to make a query with two conditions : to include all the orders having orders.Audit = True and also all the orders where orders.Suborder = true. I...

trying to construct a query field as follows. Expr1:DLookup("[Value}","tbl1"," Value1= ClientNum And Value2 = ID"), where values ClienNum and ID are fields of...

Hi to Everyone I have a table (tblMunka) with the following columns: JobId; PersonalId;AreaId;StartDate;EndDate;ActiveJob I would like to a query which tell me...

I have a word merge, trying to merge from my field 'GENDER' which holds the either Male or Female. In the word document, I have to ask the question twice. I...

I have a form called that stores the vehicle fleet number, registration number, vehicle type etc etc, that has a sub form called on it that takes its data...

Could you please tell me what is wrong with this SQL statement. I am trying to get the patient info from one table and the results from another table. I...

Hi, I am looking for a query to take 7 different fields, and produce a result if ANY of the 7 fields are blank. If I use the "Is Null" function in each...

Either i have a problem with this query or i am the problem. i have query that combines data from two tables. but somehow, when i try to add another column to...

Hello I have something wrong with my query and i can't seem to find it I want to select put a position number on each of the rows based on "Completed" date I...

Receiving Ambiggious anme in query expression: strTapes: FillVolSer()

I have 2 tables(Status and Deficiency Tracking) that are related by StatusID. Purpose of these tables are to track deficiency status until it is corrected or...

I have two tables and I want to compare the name fields within them: table: allusers Name - in the format LastName FirstName Email table: leavers: Last...

You can find my DB schema he http://www.geocities.com/jacobpressures/NewDB.JPG The problem that i've been having is that there are several correct...

Here's the query: SELECT TblDL.SecNm, TblDL.CUS, TblDL.Ex, TblDL.Pay, TblDL.Grate, TblXZ.CUS, TblXZ.Ex, TblXZ.Pay, TblXZ.Grate, TblDL.Ctry FROM TblDL,...

Hi, I have the following situation, I have a linked MySQL table which is populated, and a blank Access table whose schema matches the MySQL table as closely as...

If I have a field which is in memo format, and contains a lot of text, how do I create a query so that just one particular word is picked out of that text?...

I am making a database of my company with the items that we have in every office. I put a code for every item and I make a separete table for every...

Hi, I have 2 tables, tbBaby and tbVaccineInjection. tbBaby stores the babies' personal data like Name, BirthDate etc., tbVaccine stores VaccineName,...