Show All Records

[Guest]

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.

 

[tina]

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

 

[Stefan Hoffmann]

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 <--

 

[Guest]

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,

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 <--

 

[Stefan Hoffmann]

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 <--