I have 2 tables that contain the same data. One table has some deletions made to it. I would either like to delete from the 2nd table at the saem time, or...

I have a report that counts the number of surveys sent, the number of surveys returned, the number of responses based upon satisfaction (1=very satisfied,...

I'm somewhat new to access, and I'm trying to set up a parameter query. I have tried Criteria: , but that doesn't work. Can anyone help me out?

CompTotalDiff: IIf(IsNull(),Null,IIf(100,100- )) I believe this requires "Val" as it returns #Error if CompTotal is Null. If there is a value it returns...

Hi Everybody! I have two tables: 1)Books 2)Trans , I want to make a query that will only show fields that I don’t have in the table trans For example in...

I am hoping someone has had some experience here. In my query, I need to seperate a Timestamp into two different fields; a date fiend and a time field. I am...

Is there anyway to time how long a query takes to run?

Hi I have a table where I have a field which is a combobox. And when I choose a value from that combobox I would like another field's value to change. The to...

I have a query with the following fields: Cost Center; Salaries-Projected;Other-Projected These fields result from a combination of SELECT queries that I have...

I have a query that has a crieteria under UNIT # of 'Not Like 'S*'. I would like to keep this criteria but add that certain unit #'s that do start with 'S'...

A simple question but I'm stuck: any idea why my query won't let me add more fields? I'm no where near the 255 limit. I'm creating a query where most of...

I just set up a simple pair of tables (Tasks, Systems) in A2007. I now want to "Cross" them, so I get one row for each Task for each System. That is, I...

Hi, I have a table collecting the data for division, people and cost. How can I write a query to find out who are the top 5 people spent most of the money in...

Is it possible to use an update query to "check" a yes/no field? I have an employee table that I track Active employees. If the box is checked then the...

Hi I have a field called Income with values such as employeed full time, part time etc.. I would like to count the number of times these values are in the...

I am trying to append new data from a table I imported from a SharePoint list back to the same SharePoint List. The append lists the correct records, but I...

Is there any way to create a row number in a query? For in example, in Excel you can just do a =ROW() to get the row number, anything like this in Access?

I don't use Access often, so I know the issue I am struggling with is due to my inexperience. I have several queries based on 3 tables. For the 1st...

Hello: I have an MSAccess report needing some changes. The report contains a field. The status field contains a variety of data (Signed, in coordination,...

To simply the question I have a orders database with the following fields: Order Number Model Number Options. each record contains the same order number for a...