Recent content by Malachy39

I have a form 'Form A' and a subform "Form B". The subform is master and child linked by a field called IP Address. the subform "Form B" references the following fields: IP Address Date Meter Read I want Form A to show the first record from the subform; it should show the value of the field...

Thanks for the reply. Where exactly do I type: SELECT table.DateColumn, table.CurrencyColumn-table1.CurencyColumn FROM table, table AS table1 WHERE table1.DateXColumn= (SELECT MAX (table1.DateColumn) FROM table AS table1 WHERE table1.DateColumn<table.DateColumn); Datecolumn = your...

Sum of difference Column A is a date field Column B is a currency field. How do I query the difference between record X and record X+1. For Instance. Date Currency 1/1 $310 1/2 $432 1/3 $500 The query should show on the second line $122 and on the third line $168. Thanks for you help.

Column A is a date field Column B is a currency field. How do I query the difference between record X and record X+1. For Instance. Date Currency 1/1 $310 1/2 $432 1/3 $500 The query should show on the second line $122 and on the third line $168. Thanks for you help.

I have a column in a query "Meter Read". It lists the meter reads of a printer on various days. For example 4000 on one day and then 4016 on the next day. 4132 on the next. How do I build an expression so that it reads the difference between each day? i.e. the first record will show 0, and...

Age Thanks so much. I even added the following: Format(Date()-[Installed],"yy"" years ""mm"" months""") So that it returned.... 03 years and 04 months. Pretty cool!

I created a field called Age in a query. I built an expression... Age: DateDiff("m",[Installed],Date()) It successfully returns the correct number of months. But how do I make it show a different format, i.e instead of 48 months it returns 4 years, instead of 43 months it returns 3 years and...

I created a field called Age in a query. I built an expression... Age: DateDiff("m",[Installed],Date()) It successfully returns the correct number of months. But how do I make it show a different format, i.e instead of 48 months it returns 4 years, instead of 43 months it returns 3 years and...