Show All Records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sunshineleo - 17 Dec 2006 04:06 GMT

Hi,
I have a report where I want to show all records. It's a quarterly report
where the user inputs the quarter they are interested in. What displays are
only the rows where there was activity during that quarter. I want to show
all. How can I accomplish this?
I'm sure this is really simple and I just can't seem to figure it out.
Thanks.

Reply to this Message

tina - 17 Dec 2006 10:09 GMT

if your table has a field that indicates whether or not the record "had
activity" during a quarter, then i'd guess that you have criteria set on
that field in the query underlying the report. if so, remove the criteria.
if not, then you'll need to provide more information about the table, and
post the query's SQL statement.

hth

> Hi,
> I have a report where I want to show all records. It's a quarterly report
[quoted text clipped - 3 lines]
> I'm sure this is really simple and I just can't seem to figure it out.
> Thanks.

Reply to this Message

Stefan Hoffmann - 17 Dec 2006 10:11 GMT

hi,

> I have a report where I want to show all records. It's a quarterly report
> where the user inputs the quarter they are interested in. What displays are
> only the rows where there was activity during that quarter. I want to show
> all. How can I accomplish this?

To filter your data, you need to modify your RecordSource to filter your
data. Create a new query based on your existing table or query. Add a
field Quarter, in the SQL view this looks like this:

SELECT Expense.Id, Expense.ExpenseStartDate, Expense.ExpenseEndDate,
Expense.Comment, Format([ExpenseStartDate],"q") AS Quarter
FROM Expense
WHERE (((Format([ExpenseStartDate],"q"))=[Enter quarter:]));

Build your report on that query.

mfG
--> stefan <--

Reply to this Message

sunshineleo - 17 Dec 2006 19:14 GMT

Is there some other way to do this? I have Expressions in my query that won't
copy over. I'd have to redo them... about 20.
Thanks.

> hi,
>
[quoted text clipped - 15 lines]
> mfG
> --> stefan <--

Reply to this Message

Stefan Hoffmann - 18 Dec 2006 09:02 GMT

hi,

> Is there some other way to do this? I have Expressions in my query that won't
> copy over. I'd have to redo them... about 20.

Just use your query as source:

SELECT *, Format([YourDateField],"q") AS Quarter
FROM YourQuery
WHERE (((Format([YourDateField],"q"))=[Enter quarter:]));

mfG
--> stefan <--

Reply to this Message