I have a query that lists records out of table. A field contains a double
value with 0 to 9 decimal places. A second field contains the number of
decimal places the value has to be rounded to.
So the query looks something like this:

I have 2 questions. I'm new to Access and have a high level DB class
where the current project is simply to implement a db using Access. I'm
relatively familiar with SQL and so far haven't had any issues with the
actual queries.  We have to create tables, populate them, and then ...

I have a number of calculations that build on each other , originally based
on some fields and I need the interim results as well as the final one. I
also at one point use a function that I wrote myself and is held in a
module. Now, I can do all these calcs in a control on a form or ...

I have created a bunch of employee records in my data base.  I would like to
have a Drop-down menu that has all of the last names of the employees and a
button that would open the <Employee Data> FORM with the record that
corresponds with the last name of the employee when the ...

I have a query and want to set up the criteria for filtering.  I have one
field for date [EntryDate] and another field called [Company].  I would like
to search for companies that have a certain date.
What I can do is [Forms]![QUERYNAME]![EntryDate] this will get the correct

Acess 2003, Windows XP Pro
I am using VBA to build an SQL string which is, in the end, a MakeTable
query from a Union Query.  My basic stucture being:
SELECT * INTO tblMyNewTable FROM (SELECT.....UNION.......)

Hi group,
I'm looking for help getting a query to populate a listbox. My table is elec
and I'm trying to fill a list box from a field called signtype
where the value I'm looking for is "new rdr sign"  I want to display the

I want to update a table:
Student table
  Student_ID <primary key>
  Students_Teacher <lookup field> from Teacher table

Is there a way to automatically import a list of all files from a specific
folder & create a table that has hyperlinks to the files?
We have procedures (usually word documents) that are added all the time from
many users & put into a specific folder. I would like it if the user ...

I keep getting a "type conversion error" while using the dsum function in an
update query.  My sytax is correct and the two tables are linked

u might  find this question strange but
how to generate a null value in a sql query (Ms Access)
the Table1 contains only 3 fields
name

Hi, I'm puzzled about why this won't work.
I have: =IIf(IsNull([Onstrm]) And IsNull([Offstrm]) And
IsNull([Unclass]),Like "*",[forms]![Select Reports Menu].[Onstrm] Or
[forms]![Select Reports Menu].[Offstrm] Or [forms]![Select Reports

I am trying to make a query to show a count of how many subjects have Moved
(True/False), grouped by School. If no subjects in a certain school have
moved, I’d like the query to return a 0 instead of simply omitting the group.
For example:

how to change "02.32 h" to 152 minutes?
thank you
Gianni

I have a small HelpDesk system that stores the agents answers (fldA) in a
column.  It's easy enough to find out how many cases have been created, but
I'd like to know how many times an agent has touched the case.  For example,
the customer complains their product doesn't work.  ...