I have a database with payroll records. A sample of the data looks like this Emp# Adjustment Code Netpay 123 50.00 NT ...

To begin with, I choose: Modules/New and I paste: Public Function GetLetters(strBookCode As String) As String Dim lngCtr As Long Const conAlphabet As String =...

In the query design window I have two tables: "SumofSuppCost" "SuppCost. The aim is to supply the last cost paid for an item irrespective of supplier. I...

hi all I am facing the wierd problem of cummulative addition. the table looks like 10172 9/08/2006 MAJOR $12.00 MAGNESIUM $3.00 ...

I am trying to construct a crosstab query to display product competition for companies in a region, including reporting what cities do not have companies...

I have a table with 4 fields: SONumber, InvDate, InvAmount, Complete (Yes/No field) The table will have multiple records for many SONumber's. I need to write...

Is there a way to get Access 2003 to get past the whole number limit for top percent? I'm crunching a large amount of weather data for a particular station...

Hi All, Can anyone point me at a some basic bracket matching freeware please?? Having a mare with some old long SQL statements that I am trying to sort...

I've seen similar postiings but can't find the right answer... I've got a form with 4 combo boxes (location, start date, end date, customer). I want the...

Greetings, I have a question for the group that I hope somone can help with. I have this query I'm wrestling with: The query has a criteria value that...

I found this query that claims it can display the maximum (latest) date in multiple columns containing dates. I have a table that contains inspection dates...

I experience very strange problem in Access 2003. If I try to run quite a simple query from CurrentDb.Execute command it will crash my database. From another...

Hello, I have a query that is pulling the sum of a field in a table based on criteria. Then there is an expression field in the query that is multiplying...

Any help on this small problem would be greatly appreciated. I have numerous pivotcharts set up from a query, but would like to make it so that i can move on...

Hello, I need to load the last N records from a table. The last N records are determined by date. And I want N to be a parameter in the Query. How can I do...

Hi all, I am a little stuck. I basically want to see the first date when any person has more than 60minutes free. import_date = the date the data was...

Is it possible in Design View to list more than 9 OR criteria without using SQL? I have 12 fields and need to apply a criteria to each one to see if a...

Hi I have a Query which contains a field I want the user to be able to specify an as of date and I want that as of date to include the date that they...

I need a formula to put in a query showing the difference between two columns. I have a current amount column and a previous amount column. I need to show if...