I have a complex Query that suddently after many years of fine working started getting !very! slow. Is there a way to debug it? To see what is happening...

I have a form as follows: Main form is supplier and subform is invoices and the mainform ans subform is based on a grid query: The layout is more or less as...

I want to retrieve data from different tables in a single query based on a input given by user. Example. Product A sold for different price in different...

I want a combo box (which is placed in the sub form) to display only those rows, which falls under the creiteria given in the main form

How do I remove the subtotal groupings within a pivot table and only display the final totals. -- Rose

Hi All I have to tables and in the first one I have a key (SzemelyId) and in the other table Salary: SzemelyId, Salary, Date, Active) is Szemely Id is...

I am designing a database to manage staff absences. I have a number of forms (one for each manager) feeding one table for company reports etc. I have a...

How do I write a query for tables Client and Orders with a one to many relationship where I want only a single record per Client, with only the latest...

I have a filed called "Contact" that has the full first and last name - is there a way to break this field into 2 fields - "first name", 'last name" ??? How...

I would like to write a query where I do not have to 'hard code' a date range for a financial year. The financial year begins 1 July through to 30 June. The...

Hello! I have a field (birthdate, short date) and I am interested in finding out all those who are 50 to 60 years. I tried Year(Date())-50 and...

I have 2 access database, both with a table called Score (that has names and grades as fields). Can I query from a third access database to have the average...

Hi I have a column of amounts. I need to find the count of the maximum amount. For example if I have the below records $10 $9 $8 $9 $10

i have a table like this name dept sales rank ram purchase 230 1 bill purchase 120 2 mol purchase 40 3 steve ...

Hi, I am using Access 2002. I tried to set up an unbound texbox in form so that users can type in a value to find a specific record to update other...

Periodically I get a Mail System Internal Data email message and it says not to delete this message as it contains improtant information. What is this...

I need to know how to do an Out of Office Reply on the new Microsoft Outlook 2007 and we use Allstream as our outgoing mail server. Any help would be...

I am working with DateDiff . I get no error messages but also do not get any results in my calculated field. I have two dates, START_DATE and END_DATE and I...

I've got a query (qryMaingroup) that looks at a table (tblMain) and displays all the records in tblMain with a seat number less than a particular value. I'd...

I have some members in av form, and I want to be able to in to just type inn the persons name and search an get hold of all the persons data in the form. Is...