Joining multiple queries - the database records interest in courses and classes held and I have created several different queries: One to count students in a...

I have a test box with a date in it. Using the date value of the text box I updated the caption property of a label using the setvalue function. But when I...

hi everyone! i need help. given:querry columns of "size" & "core" problem: i need to change all the values of 2.5 to 4 in column "size" when it encounters a...

In performing a sum query, where 3 of 4 fields are "group" by, and the 4th is "count" I get a counted list of distinct items, each of which is the same in...

I have used a UNION query to join a CrossTab query and a slect to Total CrossTab. I need help with getting the Total to be the last line of the UNION...

I have a query to return true if a doc contains bookmarks. I built it in the query builder grid, and grabbed this statement from 'View/Sql" SELECT...

In the query grid I am trying to set this expression to return the first name and middle initial with a period after the middle initial FMName: &" "& & ". "...

In Access 2002 I have a simple update query, that sums the values in certain fields and places the resulting totals in existing (empty) fields. The query...

Our data entry person has enter all of our contacts into an access table using all upper case letters.......Is there anyway I can change all of those names...

Hi, While experiementing with one querry, my mdb file eat up all the harddisk memory. The mdb file is now almost 2 gigabytes whereas it should be (and was?)...

Sort of new to acces so please be kind. Here is my question: How do I get a query to search for duplicate information in the same field but in different...

Trying to incorporate 2 left join queries into 1 combined query. Basically I'm trying to get the total REG hours and OVT hours for each pay period and each...

This should be very simple. I have two queries and I want to match the two. I want the number of result records to be the same as the first query. I just want...

I have created a Top 25 report in a query that I export to Excel for our management team to review. They have requested that I include a total dollar amount of...

For reasons too obscure to describe, I very much like to segregate my overall database into several .mdb files. The main file contains queries and joins, the...

Hello: on the following field value: 8/21/2004 12:00:00 PM I am using: Iif(datevalue is null, " ", datevalue() My objective is to removed the time data. ...

I can get Access to tell me how big the whole pie is, but how do I get it to tell me what percent of the whole thing each piece represents? My table has the...

Hi Am trying to grab the top record for each group of records (by id) ordered by datetime desc. my table looks like...

I've got a table with the following format: Category Dept1 Dept2 Dept3 ... deptn Good Ergo False False True ... false Proper...

I just recently made a Crosstab query and I used it as an input in a make table query. The problem is, ever since that was done, anytime I try to open (even in...