In a sorted table, is there a way to select the first record for a group?

How do I create a search engine of some kind for my database? (without having to setup a new query everytime) I have a database which contains a library of...

I need to run a query in Access that will give us the clients who have not given us work since 2001. The problem; there are clients who have been giving us...

Hello all, I have two tables that have employees IDs as key fields. I am trying to create a query to fetch all of the employees IDs that do not match with...

Hello, I've created a query that contains two queries, with a left outer join. The query duplicates values if I don't set the query properties to...

I have a query where company name fields from two different sources need to be compared. I need an expression (or something) that will compare the first 15 or...

MASTER Table: CHARGES Fields: ChargesKey, ChargesDate Data: Row1 = 1, 01/15/2004 Row2 = 2, 03/20/2004 Row3 = 3, 04/25/2004 DETAIL Table: SERVICES Fields:...

I have a table that holds average values by week number - the last week held is currently week 21 so I now need to add data for week 22 and week 23. If the...

I am running Access2002 under Windows XP Pro. I have built a query as a row source for a listbox on a form. The first version of the query is working...

Hi, I have a products table linked to a shipments table which tracks the dates of the shipments of each product. The tables are linked by ProductID. How can...

I have a request to create a Query and not sure how to go about this. This query will look at purchase history of part numbers by a distributor over the...

I have a query with as the criteria for a field I use to request a password from a database user. The poroperties for the reaponse field suggest that the...

I have a query (thanks to this group) which returns the very last date in a sequence. This query works great. I now want to use it in another query where I...

I was trying to execute an append query that gets input parameters from a form using a macro but I think what Help just told me is that I need to use the DoCmd...

Fred and Tina were kind enough to try to help in an earlier thread but I'm still getting nowhere. I have a simple query that works fine but the user must type...

hello all i am attempting to create a parameter query, which is where you would put in the "criteria" section in order to have access prompt you with a text...

I have a MAKE TABLE query that updates the information from one database to another. Now I would like to have this table updated automatically. I have linked...

Hello All I trying to create a query in Access that will only select data from a table when it exceeds a certain length i.e. Col A | Col B Row 1 A ...

I need a function to remove the decimal point not the decial place. I need to provide a data file with dollars and cents without the decimal. Thank you

I am trying to call the following module (which I borrowed from "The Access Web") to calculate the number of business days. Here is the module: Function...