Default on Report

  • Thread starter Thread starter ladybug via AccessMonster.com
  • Start date Start date
L

ladybug via AccessMonster.com

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?
 
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
 
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
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).
Click to expand...
[quoted text clipped - 5 lines]
not.
Any thoughts?
Click to expand...
Click to expand...
 
Back
Top