I HAVE A QUERY IN ACCESS 97 THAT RETURNS 30 OPERATIONS (OPERATIONS IS A
FIELD) FOR ONE JOB (JOB IS A FIELD) IS THERE A WAY TO HAVE THE 30 DIFERENT
OPERATIONS BECOME FIELDS? SO I GET 1 RECORD INSTEAD OF 30

I want my query to use one of it's own fields as a prompt before it runs.
The field in question is a combo box, so there are 4 choices one can make
when they are entering the data on a form. When I run the query, I want the
combo box to pop up and ask me to select a choice, and ...

I'm trying to use a cross tab query to get a total amount of money for
a set of subgroup accounts.
Once I have these totals (One total for expenses and one total income)
I need to find the difference but the problem I keep running into is

I have an address file with 50k records
The fields are Add1, Add2, - Add6, Postcode
The postcode field has such information but this information is also
duplicated in various add fields

Accidentally posted this in "General."  Sorry.
I'm trying to select records from several tables at once:
SELECT Units.[Unit ID], Units.Building, Units.[Room #], Units.[Hood #],
Nz(Max([Inspection Date]),"Not inspected") AS [Last Inspection],

I have a number of different conditions which yield the same result. I tried
(what I thought was) a straightforward IIF statement
IIF ( [ABC List] like ( "AB*" or "CD*" or "EF*" ), "ABC","")
But that didn't give me results. (When any of those conditions was met, I

I need to create a report where I consolidate multiple records from 1 table
and join them to 1 record in another.  The problem is, I need them to all be
joined into 1 record.
tblStudents (Name, LocID, Grade) - Single record per student

Ok.  I've got a group of people located at mutliple offices who are members
of different committees.  I can't figure out a query to create which will
show the office they are in, the first and last name of the person, and the
committees that they are part of.  There are multiple ...

I'M NEW TO ACCESS 97 AND I HAVE A QUERY WITH A FIELD THAT HAS 10 REPETITIVE
RECORDS IN IT IS THERE A WAY TO TURN THOSE RECORDS INTO FIELDS

Can anyone help me?
I have one parent table StaffID primary key that holds a Balance Hours.
I need to apply this balance apportioning it to a child table StaffID/Date
as the primary key with a field of PLanned hours and Used Hours.

Hi
I'm using len and left function to get a value but the result is #Error.
The RATE is in TEXT format with value like 64K,256K. the idea is to get only
64 or 256 and change to numbers.

Hoping someone can help me find a solution to the following problem I
have.
I have a query that currently pulls the following information from
Table A

when I converting a negative value to hours sometimes the convertion is a
wrong.
If I have -2.5 that means -2:30h, it converts to -3:30h, but if I have -8,
it converts to -8:00h

I have (main table), tblAction with actionID, title, name. Another table
(child table), tblRemarks with remID, actionID, remDate, Remark
I would like create query/report to show all record from tblAction but show
only the top 3 remDate on each group actionID from the tblRemarks.

I am currently setting up a database for managing sickness absence. The dates
are recorded as follows:
1st date of Absence
Last date of Absence