Recent content by AndeanWayne

My database has a table tblCombinedPropInvest which is a temporary table. Four of the fields in this table are Tax year, State, County and PIN Number. These fields are entered in a data entry form. When all entry is made and append query calculates a PropertyID field and the records are...

The problem is that a property may be both Redeemed and Abandoned but the statement only provides that is is Redeemed. I'm looking for a way that it will identify that it is Redeemed Abandoned. Once it meets one condition is stops.

I have a report with the following equation to give a status message at the end of the report: =IIf([RedemptionDate] Is Not Null,"THIS PIN HAS BEEN REDEEMED",IIf([DateAbandoned] Is Not Null,"THIS PIN HAS BEEN ABANDONED",IIf([DateSaleInErrors] Is Not Null,"THIS PIN IS A SALE IN...

So assuming my one formula is: penalties=([RedemptionDate]-[CertificationDate])/182.5)+1 where does the following go?: If [RedemptionDate] is null use Now, if not, use [RedemtionDate] to trigger using the Redemption Date or Now()

I have a query which is the data source for a report. To find the correct number of penalty periods the formula is penalties:(([RedemptionDate]-[CertificationDate])/182.5)+1 which is fine if there is a redemption date. It give an initial penalty then another penalty each half year. But if...

I opened the object dependencies window trying to print the information in the window for lack of a report. The dependencies window opened on the far right side of the screen as always. Somehow in trying to print more of the window I moved it and now it opens across the entire width of the...

I have a form based on a table with a combo box to select a record. The fields in the combo box are PIN (a ten digit number to identify a property: example 0208101010) and PropID (a field identifier made up of the tax year, state, county and PIN - example: 2008-IL-Lake-0208101010). PINs can...

Record First Where Condition ="[PIN_Number] = " & "'" & [Screen].[ActiveControl] & "'"

I have a form for entering property tax. The form is based on a table called investments. The form contains a combo box to select the appropriate property for data entry to the table. The two fields in the combo box are Property PIN and Property ID. The property ID is a combination of tax...

I have a database with two related tables based on a property ID code. I want to have a cascade delete so when I delete a record in the property info table the related record in the investment table is deleted. The rpobelem is this is a one to one relationship because the PropertyID is the...

The users are familiar with the PIN. The same property can appear in subsequent years. The combo shows the PIN and the PropIDs (unique ID) for each PIN as separate records. They also show as separate records in the table and query. But, the combo box will only select one of the records (1010...

I have a form to modify existing property records. Each record has a PIN number and a unique ID which is a combination of year, state county and PIN. The same property can have a record for more than one year. On this form I have a combo box for selecting the record to be modified. The...

Thanks to you both. It works great. Tried something similar but a macro had the form closed. Now with the form left open I get exactly what I want.

I have a report based on a query with a between two dates parameter (Begin date and end date). This parameter is fed from a form. All works well - query, form and report. My question is can the date parameter appear on the report header so users know the report was based on a start date of...

I have a parameter query where I have paramers for the fields: completion date between two dates, State, County and Buyer Number. Everything works great. But, I want to be able to either select a buyer Number or have the query show results for ALL buyers. I tried {Enter Buyer Number] OR Like...