Search results

I have a crosstab query. TRANSFORM Sum([tblSales].[Quantity]) AS SumOfQuantity SELECT [tblSales].[Area], Sum([tblSales].[Quantity]) AS Total FROM tblSales WHERE ((([tblSales].[Year])="2003")) GROUP BY [tblSales].[Area] PIVOT [tblSales].[Quarter]; It contains some null values. I need to use...

Hi everyone. I have a table [tblEmployee] from which I need to calculate the employees' ages and lengths of service from the fields [DateOfBirth] and [DateJoined]. For the Age Calculation I have successfully used an expression that I found in these forums (see the query in the attached Access...

I don't know if this is possible. I have four fields [StartDate] [StartTime] [EndDate] [EndTime] along with other fields imported from Excel into an Access 2K table. In a query, I need to show the time elapsed between Start and End for each record in the format: ? day ? hr ? min ? sec I know...

I have an invoice summary table with the fields Invoice#, CustomerID, EmployeeID, InvoiceDate and InvoiceAmount. I want to show in a report only the top 3 InvoiceAmount for each customer. Is this possible? Do I need to build the report based on a query or filter the report when it is printed...