I need to calculate multiple values for a field called CSP that will be based on a calculated field called Days. Days is calculated by using DateDifference...

I have a set of ContactIDs, EmailAddresses and EmailAddressTypes (1=Bus, 2=Bus&Pers, 3=Pers). I need to return a list of 1 email address per Contact and where...

I have created a DB to use in a Powerball pool. I have on table for our picks and one table for winning numbers. I would like to create a query that would...

Hi all. I'm still struggling with subqueries a little bit. I'm trying to combine two queries here. Both are pasted below and run seperately, the 2nd is the...

How can I do a calculation using two calculated fields without getting Error 3203 - "Subqueries cannot be used in the expression expression". For example,...

I have a query that is intended to update the quantity and total cost for items purchased. This query is run after a new purchase order is entered. It’s...

on my query based on two tables & , how can i display the Contractor (or Company) with the highest number of NoShows? ContractorName = Text Field NoShow =...

I have a query which I built on the grid. It used to work. I added a field, and it does not work anymore. It hangs access. Here is the thing. NO part of...

Hello, I created this db in MS ACCESS 2003 and recently our office upgraded to MS ACCESS 2007. Everything was working fine, until a User noticed that after...

Hi, I have an Access 03 query based on “Tbl Vol Hours Tracking�. In my query, one of the fields uses the following to calculate the total number of...

Thanks for any help. I have a table and a query that I input into an Excel spreadsheet, match up a couple of fields, subtract account value if they match,...

I have IIF stament in the query criteria and would like return a text like following "CURRENT", "PAST", "CURRENT" or "PAST" It works for single criteria like...

Hello all. I am creating a database to track repair costs on products. I want to use a form to select between 2 dates entered in the 'DATE SERVICE CLAIM...

In Access 2007, I am building a db to help manage a homeowners association. The task is to create a record of association meetings. In this task, I need to...

Greetings, I have a simple pivot chart that are reporting 30 rows of records with 15 field headers where the chart opens however not all the data will be...

Wondering if whether you can use an OR in a join. currently I have a table (principal_data_export) with variable cdscode & altcdscode I want the table to...

I am trying to make a query where I have one table "call it products sold " that has the price, lbs, QTY of the sku's.... I have a second table "call it...

I have setup a query to look for inappropriate data. I then setup another query to count the number of records in the first query which are then reported on...

I maintain a database of shipping records which I update weekly. The database is largely used for simple queries about our shipping activity, and is not...

I have a Query that lists anyone enrolled that is a senior... it is querying from the college's SIS database. Then I have a table called "Withdrawals"......