Show All Records

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
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?
Click to expand...
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 <--
 
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.

Stefan Hoffmann said:
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?
Click to expand...
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 <--
Click to expand...
 
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.
Click to expand...
Just use your query as source:

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

mfG
--> stefan <--
 
Back
Top