Formating Issue in a Query

M

Midland

I am running a query and have several calculated columns. One of them is a
simple summing of values on the record:

QRateID: [PN]+[Seq]/1000

The others are drawing from another table, the first being:

QRateNum: DLookUp("RateNum","datalink","[RateID]=" & [QrateID])

The first calculated expression has the same options for properties as the
other fields in the query: Description, Format, Decimal Places, etc., with
the usual options for Formating.

The second, no matter how I build it, has no line for "Decimal Places" and
the "Format" property offers no options. Literally, the drop-down box is
empty.

Why is this happening? The dlookup is pulling text from some columns,
numbers from others. One of the fields is three decimal places in the
original table, but is seven in the query. Literally, it isn't formatted at
all.
 
K

KARL DEWEY

You need to check your math on the first one.
Maybe this --
QRateID: ([PN]+[Seq])/1000

Or this --
QRateID: [PN]+([Seq]/1000)

Wrap the second one in format like this --
QRateNum: Format(DLookUp("RateNum","datalink","[RateID]=" & [QrateID]),
"Xyyy Yzzz")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DLookUp for an Alphanumeric Record 3
Access stripping decimal places in query 1
Number Format in Chart Datasheet 1
Filtering in a Query 5
format a number field to only show 2 decimal places if there are a 6
Specify Input Mask Format in Query 6
How do you turn off automatic rounding in a query IIf statement? 2
Calculation in Update query drops decimal places 2

Top