Update to thread "Calculating in Access"

[nala1]

PHV...I will try that. But now I have another one. When I ran the query on the AS/400 I didn't omit any records so the data transfer to my PC (and ultimately Access) contains records I'd like to filter out of the form. How can I show say, all receipts for a selected time period BUT NOT lose any of the other data in the form? If the date is say older than 01/01/2007 I don't want it to populate the field. Thank You!

 

[lameid]

nala1,

I understood you your post to mean you want to not to keep or display some value in a single field if it does not meet certain criteria. This is different than filtering as filtering eliminates entire records.

You can't really do this if you want to be able to maintain the data easily.

You could add an extra field/column and update it with the initial date values and then update all the original field to null for the dates in question.

Or for display purposes you could hide it (see below), but then you won't be able to update it without some code...

IIF(DateField <#1/1/2007#, Null, DateField)

 

[lespaul]

it is usually considerate to provide a link to a previous thread when referencing in a separate thread, Thread181-1417576

Leslie

Essential for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins