On 9 Oct, 15:21, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
A1: There is no problem with selecting several controls at once, and then
setting their Format property in the Properties box.
I'm sorry, but I'm a novice to Access and don't quite follow you.
I'd like to format the way Access shows certain fields in tables and
queries (e.g. set the number of decimal digits displayed). To do this,
I open the table/query I want in design view, select a column, click
ALT+ENTER, and choose the format I want from "format" in the property
sheet which appears. However, if I select more than one column and
then click ALT+ENTER, the property sheet which appears is different
and no longer has the "format" option.
I'm sorry if this may seem banal but I really have no clue! Btw, is
that the only way to format a field?
A2: See:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html
The article explains how to use CVDate() around the calculated field so JET
recognises it as a date. If you don't follow how to apply this, post your
SQL statement.
It doesn't work :(
The date fields are correctly formatted, recognized and displayed as
dates. However, I need to create another table which summarizes the
average date by type of account; The SQL code is:
SELECT DISTINCTROW [Main - with L8M CashFlows].SegmentDescription,
Avg([Main - with L8M CashFlows].Default_Date) AS AvgOfDefault_Date
FROM [Main - with L8M CashFlows]
GROUP BY [Main - with L8M CashFlows].SegmentDescription;
The calculations are correct, but I can't format the averages as
dates. I tried with CDate:
SELECT DISTINCTROW [Main - with L8M CashFlows].SegmentDescription,
Avg(CDate([Default_Date])) AS ReformattedDate
FROM [Main - with L8M CashFlows]
GROUP BY [Main - with L8M CashFlows].SegmentDescription;
Thanks!