I need to get the results from: *. and then add those results to: . Would this work? It seems I am getting different results then what I am looking...

I have a large table, tblStudents, that I want to update 1 field using an update query. I created a query from a table of grades using a between statement to...

For example, One Field is set as "Date/Time". If I want all data in the specific date/week, should I creat numerous queries on the specific date? could you...

I have the following expression in an update query. It works until I add "IIf((.="")" which gives me a type conversion error when importing. Is there a...

Hi All, I have a database with linked tables and the following...

Hello, I have created a crosstab query and I would like to use the information in a report. I can't figure out how to get the total number of Lost for Jan...

If I have a feild that has the number 54200 in it how can I trim off the 00 so I end up with 542? When I try the the left function I get the results I want...

I am attempting to produce two sub-totals. One is for the amount of money paid in to buy extended warranties, and the other is the amount of money paid out...

I have a recipie database with many tables and I am trying to make a new table based on a query. In this table I want only 1 row per ingredient. this is a...

I am counting fields to track and reward employee productivity. These are date type fields. The associate enters a date for up to three different tasks they...

HELP!!! I have a query with a date field, TransDate. I want to pull up all records where the month section of TransDate is one calendar month before today's...

Hello, I was wondering if you guys would know the best way to pursue the following problem. I have two tables, one with the unique items and another with all...

I've notice that in some queries I have different options when I look at the properties. One join type give me three options. Both values the same, All of...

I currently have a query which has sums based on whether a quote has been sent, in action, or rejected. I have built totals of these with percentages based...

Hi, Please help... I have a query buit with products ordered and How many. I am wanting to try create a Top 100 products ordered by the volume ordered, by...

I have built a query, that sums a field which is based on a combo box. As it only sums the combo boxes that are checked it gives a -1 for every input. For...

have a True/False field in a query that we want to export to a text file but when we do the true/false comes out as 1/0 Is there any way I can get the report...

This is a question for Access 2000. I need to search a large table to find specific records (the criteria will be a date) then once these records are...

I am running a query to select all payment and payment reversal records for a corporation based on company name. When I do this I lose seven records because...

I have a main employee table that used to contain about 50 extra fields pertaining to employees skills and experience. In an effort to normalize data. I have...