Can't seem to get this to work can someone please help
Expr1:Int(CDec( [DETAIL_LINE_AMT]*0.0675+ 0.005) * 100 / 100)

Below is a previous post I did and beyond the second reply I haven't head
anything else on it. I have since changed the master table so that the check
boxes are no longer in the table, they're now an interger reading either "0"
or "-1".  Now the master table looks basicly like ...

    1. Can I make and appended field form 2 fields in a query (NOT
A TABLE). The fields are mnemonic2 and mnemonic3 in qry_mnemonic based
on an unchangable table PDM?
       or

I want to write a query for updating only certain characters from a field to
a field in new table.
Table 1
Fieldname=ScripName contain first record aban offshore#www.aban.com

I'm on a vista computer, using office xp, 2mg of RAM, 2.0ghz dual core
processor.
Would you be able to look at the following query and if possible suggest any
reasons why I am getting an error message "Query too Complex" when trying to

I have a table with hours in it.
09:00
09:23
09:55

    I have a pop up form that opens when I run a report via a
macro. The query searchs for an item (drug) that has 2 different
mnemonics. (fields are mnemonic2 and mnemonic3 from table PDM) I
cannot append the table fields into a new column because the table is

hey its me again.
i have a table of alot of car names with a field marked quantity showing how
many of each there is.  like i said in the other post.
i have also made a sales table which includes the customer, the car, & how

I'm trying to build a query that will get me the Heads of Households and
here is what I have to work with:
tblHouseholds:
HouseholdID (PrimaryKey)

I'm having one of those days.  Here's the trouble: I have a table of names
(let's call it tblNames) and a related table of log entries (let's call it
tblLog) which correspond to those names.  Some names have no log entries
while others have many.  I want to query tblNames for all ...

I have a lease database which I need to input monthly rents through the
lease term based on an annual lease figure.  Example:
Lease 1 - Lease term April 1, 2005 through March 31,2008
Annual Rent: $120,000 through March 31, 2007

I need to come up with a make Invoice table qry to export into excel in the
Quickbooks IIF format. I have been goofing around with this for a week. I
think I need help.
Thank

I am running Access 2003 and am trying to create a query with an
autonumber field.  I have two tables in the query each with 7 fields.
I have 3 of the fields linked because I only want to see the values in
the query if these 3 fields are equal between the two tables.  I was

Hi - thanks in advance for help.
I have this query that will calcuate my positions on any day that I
enter. My positions is equal to the sum of my Shares on previous days.
SELECT StockTransactions.DealCode, StockTransactions.Stock,

I have a table of individuals with scores & I'd like to average the first 4
(chronologically) scores for each month.
tblScores:
Individual  Month  CreateDt  Score