My query is simple or at least I thought it was but I keep getting bad results. The Table is... Ordering Info The Field is... Qty Needed The Criteria Used...

I've got a table with computer names and IP addresses in different columns. I would like to do a search that returns all the computer names that aren't...

I have an Update Query that updates two fields , in one table (Barracks Rooms) based on one field in another table (Students). If in (Students) is Null,...

Hi I want an update query, that deducts 20% from the value of a field , assuming that is greater than zero. I also need the resulting figure to be a whole...

I made a query that uses fields from multiple tables to calculate values for daily metrics. I need to present monthly totals of the data as sums and/or...

Hi I have a import routine that imports a monthly data file into my database. As part of the routine the data is imported into a Temp Table and then split,...

I have a table that lists business summary data by day. Not every business has information on each day. However I need to pull in the business along with zero...

I can't seem to get to syntax right on this query field. The nesting goes this way: find City Name by: if JobAddress4 and JobAddress3 is blank then get...

Hello, in GUI of Access 2007 (12.0.6423.1000) SP2 MSO (12.0.6521.5000) is generally very simple to make a select query between two tables joined with two...

I have two tables, CustomerData and EmployeeData. CustomerData has all the address, phn, name, empid# of last employee to help em and custid (primary key) and...

I have a managers that do reviews on employees and i need to know if they did a review on an employee that reports to them or to another manager. In my...

I am trying to build a report about reviews done on employees. We have Managers assgined to Employees that do reviews. Sometimes we have manager who are NOT...

Hi and TIA. I have a multilist combo box on my form, but don't know how to setup my query to reference all the values selected in the combo. If you could...

I am wondering if anyone can help me parse a date field and update another field. Here's the situation: I have a date coming thru - for example: 2/1/2010 I...

Hello all- I have a query: SELECT .Ratio, .ASheave, .BSheave, .HPRating, .ADiameter, .BDiameter, .CONVENTIONAL, .ProposedBeltLength, .MinProposedBeltLength,...

I have two tables an Employee table and a Gap Table. Both Tables have the Social Security Field (SSN) in them. I also have a UPI field (unique personal ID)...

I know this must be stupid, but I keep setting two tables up in a query and it is doing the opposite of what I want. I have Project # School District School...

I have an Access database of client information with their birthdate stored in a field called Birthday, in m/d/yyyy format. I need a query that will let me...

Hi All! I have seen lots of posts here on Julian Dates, but it would take me days looking through everything to potentially find my issue. I need to convert a...

I was sent data that has address, city and state all in 1 field but I need to break it out into the 3 separate fields. the data has carriage returns(used * to...