I have a table that has the following: TransactionID Location Account CustNum RateCD 12245 6806 456748 1 ...

Hi Any help on the following would be most appreciated: I have 6 fields in a table "Log", Fields "progress 1" to 5 and a "reference" field. What I need to do...

I have a table in which I enter Job information about machine parts that are to be coated. It is related to a Parts table (each Part can be the subject of...

Hi, I wrote a query to select a record if either the name, phone number, gender or date of birth are blank. To start with I made my criteria simple and used...

Please help - I have a table with 3 columns. One of the columns is date, one is time and the last one is the value I want to average. What I need to do is...

Hey everyone, I have a problem that hopefully can be fixed shortly. I have a table called "Lines". It only contains one field, which is lines, and it...

I a query that collects the requried data into period buckets. Now I need to be able to cumulative sum. So Peroid 1 equals period 1, Period 2 equals Period 1 +...

Im trying to write code that looks like this in Pseudocode below. Im not to sure how to retreive the SQL statement of a query in an if statement. Thanks to...

Hi, I have a Access 2003 database. I run SQL querries via a homegrown application that uses ADO. The database contains 20 tables, each with the same schema,...

I have 6 make table queries that run consecutively from a macro. What they do is count individual member types all from the same table and create...

I have heard that a listing of all fields instead of SELECT * should be used in queries, but then I have seen SELECT * used by people I would regard as...

I am struggling with how to do a query that will show the information I need. First is a table (tblAttendance) with a StudentId and dateofAttendance Every...

Hello, I use Access 2000 and have a table Products (tProd), with the fields Code, Name, Category and Turnover. For this table i have the following...

My Formula Y_N: IIf(IsError((-)/),"Y","N") I either get #Error or N Thanks

Hi guys I am trying to develop a query in access to sum up the 'sum of hours' by 'staff name', per month. I would appreciate any help/comments, as i have no...

I have tried to take the SQL generated by two crosstab queries and UNION them together but I am getting Errors... TRANSFORM Sum(.Applications) AS...

Hello, I found the following searching for a query to find gap in a sequence of numbers This will find the first number of every gap in the sequence:...

Hi: I searched through many answers in group and I'm still not clear on how to accomplish this with a reasonable level of effort and within my coding...

Hi Could you please help me delete all records in front of the @ sign in an Email address Thanks Pete

I have 3 fields in a querry. I have field number 1 in a querry (called Original_SVS_ID) that can contains: hurricane undeliverable high value one...