Hello! Which of GROUP BY and DISTINCT is the quickest? and why? Thanks for any relevant answer! PS: Please don't tell me that there is no difference because...

Ted, I really appreciate your help on this. The Inception table is used to specify the inception date and the starting point for 100 in the IDTotRet field for...

Is it possible to use the column name, which is a pivot of the first column in the underlying table, in a calculation? Essentially, I want to create a matrix,...

Please help. I am trying to make updating a 'confirmation' routine quick and easily updateable by some one else. I have 2 tables, one of which I would like...

Hello all, First off I want to say I read a lot of the previous posts about this issue and none seem to be similar to mine. I am working on a database...

I would like to make a query on a table on one field to 'sum' or 'max' the field based on 'if' another field is null or not. Any idea on how I would go...

Ken you helped me last week with a query to find missing dates from my employee db. It works great except I have found that it returns all dates from my...

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...

Hi Tony, I woke up this morning thinking about how you probably (might) want your queries to be updatable. One method is putting the group by in the Where...

I have a query attached to a form. On that form I have a combo box w/ a 'notinlist' event that is supposed to add a record if the 'id' is not in the list. I...

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...

Can an activex calander be used in a query to sort out data by a date range and how can I extract from a date input say 01/03/2005, that this relates...

Hi, thanks in advance, I am very new to access 2003. I have a very simple table which is quite long, many of the fields are checkboxes. I have created a...

I received an email with attachment. Outlook Express blocked access to attachment to "suspicious email". What do I do to view attachment? Thank you for any...

What I need to do: I have some rather expensive inventory items that I need to keep track of. These are to be used in several projects (jobs). I'm trying to...

For some reason First and Last are giving the wrong data in a Totals query. I assume that somehow the data is not ordered correctly in the main table, but it...

hello i have been trying to export a query to an excel file. this query will run once and the data that it selects i want it to export to excel. then the...

I used to be able to hit Ctrl/Break to stop a running query but it doesn't seem to work in the new version of Access 2007.

I have a Report that runs fine, but the query will not "run" by itself. Any ideas out there. Thanks, Blaze

Hello, I have a query looking like this : Name.....Score.....Tested.....Date...