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

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

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

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

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

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

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

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

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

I have iif(isnull(!!),like "*",!!) as criteria in a query field. If I place a value in the field on the form the report that uses the query with the above...

I would like to be able to run a query and get a list of ID numbers and from that list of numbers use those as parameters to run another query. Additionally,...

i have an Access 2003 qry "qryP11" Payment ID Employee ID Week Number Pay Pay to date 1 4 ...

I need to implement the following logic in a report column in Access 97: IF hist_mis_cds!typgess = "", then calculated field= "" ELSE IF hist_mis_cds!typgess...

I'm working on grouping individual records together by families, and I need help creating a text field that is the combination of all records in the group...

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

Looking for the best way to do something. Best can be easiest or best practice - I'm up for either. Don't need details (not yet :) - just a general...

I currently have several crosstabs, Querys & Forms. What I need to find out is how to get the zero counts to show. I am trying to add up people assign to a...

I need to design a process that will show a rep his/her top ten customers based on sales increase from the past 60 days comapared to the same time period...

I have a opened Date and a closed date and I would like to find out the average time is took to open and close a certain record based on a Area. SELECT...

I am running a query that includes 2 tables and another query. I have one field in a query linked to a like field in a table . I would like this to be a...