On a monthly report, I am trying to flag the projects where the status has changed from the previous month by placing a * next to the status. I have tried the following in a text box:
=IIf(DateDiff(" d",[SPECIAL ASSESSMENT DISTRICTS]![DateModified],Date())<31,"*" ," ")
I am calculating the difference in dates between the current date and the date the record was last modified. If less than 31 days, return the *. If greater than 31 days, return nothing. However, I keep getting an #Err in the print preview of the report.
Any suggestions are welcome.
3 1958 Rabbit 12,516
Recognized Expert Moderator MVP
What's [SPECIAL ASSESSMENT DISTRICTS]? Access will have no idea what this is. If it's on the report then you don't need it. If it's on a different object then you need [Forms or Reports]!SPECIAL ASSESSMENT DISTRICTS]![DateModified].
What's [SPECIAL ASSESSMENT DISTRICTS]? Access will have no idea what this is. If it's on the report then you don't need it. If it's on a different object then you need [Forms or Reports]!SPECIAL ASSESSMENT DISTRICTS]![DateModified].
[Special Assessment Districts] is the name of the table under which Date Modified is stored. should I reference it from the form from where it would have been entered?
Rabbit 12,516
Recognized Expert Moderator MVP
[Special Assessment Districts] is the name of the table under which Date Modified is stored. should I reference it from the form from where it would have been entered?
You can't reference anything that's closed using that method. You can't reference tables and queries at all using that method. You can use the D functions, DLookup in particular. However, it seems like you should be including date modified in the query that the report is based on; that way you won't need to reference anything. You can pull it directly from the report's record source.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Michael Bulatovich |
last post by:
I have a very simple db I use for keeping track of hours, tasks, projects,
clients etc. It has a form that I use to enter data. Currently the form has
a textbox for a field called "start time", another for a field called "end
time" and a third for a field called "hours", among other controls. I now
type in the approximate times in the first two textboxes, and mentally
calculate and enter the difference or elapsed time in the third.
I...
|
by: JMCN |
last post by:
object invalid or no longer set - confusion of the recordset in access
2003.
i am currently converting from access 97 to access 2003. majority of
the codes converted over perfectly fine, though my recordset did not.
i read from pasts posts that some references will not convert. so i
tried to change the dao 3.51 reference to dao 3.6 in access 97. then i
imported all of the objects into an access 2003. it did not work.
so my second...
|
by: cyranoVR |
last post by:
This is the approach I used to automate printing of Microsoft Access
reports to PDF format i.e. unattended and without annoying "Save As..."
dialogs, and - more importantly - without having to use a commercial
program such as Adobe Acrobat and its associated API.
The technique uses Ghostscript and Redirection Port Monitor - two free
programs for creating PDF documents provided free by Russell Lang. The
actual automation requires VBA...
|
by: migueltxa |
last post by:
Hi all,
I have a problem with some calculations in MS Access 2003. I have 3
fields (Qty, Price and VolumeUSD) in a form and the following formula:
VolumeUSD = Qty * Price.
Qty and VolumeUSD are formated as "Standard" and Price as "General
Number".
Example: Qty = 4,400 ; Price = 39.1602
|
by: audleman |
last post by:
I've been programming in Filemaker and am used to having a field type
called Calculation. An example of a calculation: In a school
registration database I have a date field corresponding to the start of
a quarter. I create a Calculation field to automatically generate a
human readable text string that looks like 'Spr 2005, Wi 2005, etc'.
Is there a way of doing this in Access?
Thanks,
Kevin
| |
by: Bob Alston |
last post by:
I am looking for Access reporting add-in that would be easy to use by
end users. My key focus is on selection criteria. I am very happy with
the Access report writer capabilities. As far as development of
reports, it is certainly fine in my book.
But for end-users, with little experience or training, it would be nice
to have an easy way to handle various selection criteria, perhaps with
relatively stock reports. I see easy to use by...
|
by: salad |
last post by:
Hi Guys: I was stuck. I needed to send a report to a file. My
beautiful report(s) in Access were going to require loss of formatting
with RTFs, a PITA in WordMailMerge, sending it as a text file...whatever.
I described my situation to the guy I'm doing work for and he did some
research for me and came up with the following link.
http://www.novapdf.com/
The part that should excite us Access developers is their SDK
|
by: The Facilitator |
last post by:
Well, Outlook seems to be making my life more and more challenging.
Categories are added in one field and are delimmited via comma. Have
three questions on this one...
The first is right now my query will only check the first characters
in the field to confirm whether they match the original split I did
with the other code I showed under VBA breakout (you'll notice I used
the code in the part I show here for part two and three of this...
|
by: sphinney |
last post by:
All,
I'm not sure how to adequately explain my problem in two sentences or less, so at the risk of providing TMI, here's the condensed verion.
I have developed an Access 2002 database file that contains a form, multiple queries and multiple reports. The purpose of the form is to allow the user to run various queries against my company's Sybase server and display a report.
Since the queries return ADO recordsets from the Sybase server,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |