Default on Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ladybug - 21 Nov 2006 17:04 GMT

I have a table that has a field that has each day of the week and then TBD
(To be decided).
TBD is the default for this field.
I created a query with a command for the "day field" as stated above. This
query is also linked to a report. When I run this report I want the user to
be able to type in TBD and it return all the listings that have not had a day
selected. I thought since TBD is the default this would work, but it does
not.
Any thoughts?

Reply to this Message

Daniel - 22 Nov 2006 16:05 GMT

I'm not sure if I understood properly, but why not simply have a listing of
the days of the week (forget about the TBD option) and to get the listings
that have not had a day selected simply use the IS NULL in your query.

If I misunderstood write back and will give it another go! Also, if my
answer does not work for you, could your elaborate on the week day field. Is
it Monday, Tuesday, ... or is it a date field such 2006/12/23?

I hope this helps,

Daniel

> I have a table that has a field that has each day of the week and then TBD
> (To be decided).
[quoted text clipped - 5 lines]
> not.
> Any thoughts?

Reply to this Message

ladybug - 27 Nov 2006 16:17 GMT

The report is using a query. The query prompts the user to enter a Review
Day. The Review Day is Monday, Tuesday, Wednesday, Thursday, Friday, and TBD.
The default is TBD. However, this day is in another table and until data is
entered it does not exist in this table.
I understand I could run this same report and say IS Null and these entries
will be returned, but that will not work since this report is mainstreamed
for multi-users to be able to prompt different review days or TBD.
Did I explain it any better? Any other suggestions?

>I'm not sure if I understood properly, but why not simply have a listing of
>the days of the week (forget about the TBD option) and to get the listings
[quoted text clipped - 13 lines]
>> not.
>> Any thoughts?

Reply to this Message