Hi
I have a query with a calculated field [Responsrec]-[dateSent]&"days" some results consist of 0 days, I would like to omit these but I just can't seem to get the criteria correct to do this, can anyone oblige please.
Braddy
Results 1 to 3 of 3
Thread: Calculated Field (Office 2003)
-
Silver Lounger
- Join Date
- Dec 2000
- Location
- Northampton, Northamptonshire, England
- Posts
- 1,911
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2004-02-26 05:39Calculated Field (Office 2003)
If you are a fool at forty, you will always be a fool
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Plutonium Lounger
- Join Date
- Mar 2002
- Posts
- 84,353
- Thanks
- 0
- Thanked 10 Times in 10 Posts
2004-02-26 07:10Re: Calculated Field (Office 2003)
If you already have the ResponseRec field as a separate column in the query grid, enter the following in the criteria line for this column:
>[DateSent]
If you don't have ResponseRec as separate column yet, add this field to the query grid, clear the Show check box and enter the criteria as above.
-
Silver Lounger
- Join Date
- Dec 2000
- Location
- Northampton, Northamptonshire, England
- Posts
- 1,911
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2004-02-26 07:27Re: Calculated Field (Office 2003)
Hi Hans
Once again I am in your debt.
Many Thanks
BraddyIf you are a fool at forty, you will always be a fool
