Thanks for taking the time to read my question. In my query design I want to have the following critera in the criterial line for a field =(!/10)-0.5 And...

I've created a union query that feeds a report of combined data. The 2 tables that make up the union query have some Memo fields. When the report is run the...

I have a table that looks like the following: ID ProgDate 1 1-1-04 1 1-15-04 1 2-4-04 2 1-12-04 2 1-29-04 I need to find...

I have a data table reflecting tasks and personnel assigned to complete them. The personnel may be assigned to either of two different roles depending on the...

I am tring to perform an update on columns within an access table. However at design time the columns I wish to update are undetermined. Is there a way to...

B'H This should be easy: I am using a subquery to make a simple calculation within a query. Now I want to see the average of the column that resulted. Is...

Access 2002. This is a repost with some updates. Once you are on the third of fourth page of the newgroup you are history. Anyhow, here goes. I have a...

Can a crosstab query list values without aggregating the "value" field? I want to take a table of inputs and basically turn it 180 degrees to show a calendar...

In my crosstab query, the short date sorts like: 6/1/04, 6/14,04, 6/20/04, 6/9/04 which although is textually correct does not represent the correct order...

There are several of us using the same SQL database, and we all use Access XP to get data. The problem is that the queries are all being stored right on the...

Every week I delete and recreate a table that has the firms that have been contacted the most to the least YTD. So I need to tag the top 15 with 1,2,3-15. And...

I am using Access 2002. I have fields where the entry is picked from a table with 2 columns. One column is an ID number, the other is a word or phrase. When...

I get "You cacelled the previous operation." error when I try to run a query. I have a form with two drop down boxes, a begin and a end date and a button that...

In a table containing employee information, I have a field that shows birthdate as MM/DD/YY. How would I write a query that I could use a parameter box that...

I have a table that has info and some of the phone #'s are duplicated. The numbers that are duplicated each have its own code and I need to delete one whole...

Hi I have a query that selects all employee details and the date where they worked on a particular job. I have used the syntax: ORDER BY Date, to order the...

Hi I want to email the current record in the form. Basically after I update a record I want to notify users that this record was changed via an email. I would...

i have a table with transaction information. i also have a table with account rep information. not all transactions get credited to an account rep. they will...

I would like to use a query to generate a list box that pops up when entering data into a table. I would like the query to run with a selection criterion that...

Separately, these two queries (qryPeriod_All and qryY1)are working. But, by using the following query Y1 column is empty and I don't have any idea why it...