Newbie-styled help with reports

[Bloodrayne]

Hello,

I've recently been asked to update a work Access database - which would've been no problem a few years ago, when I was fully versed in such things - however, since those heady days - ring rust has crept in, and some things I thought Access did are actually things from other programs... I'm only 23! I can't be senile!

Anyway, is there anyway in Access reports to have the user-define some of the data (such as a date range) without them having to create the whole report themselves (as they're technophobes)?

Any help is appreciated!

 

[Brianwarnock]

Drive the reports souce query from a form , the selection criteria is then pickedup by the query from the form, is the memory coming back?

brian

 

[Bloodrayne]

I don't know - I must've took some serious knocks to the head in the intervening years...

But that sounds familiar, cheers!

 

[Brianwarnock]

When you get to my age you don't need knocks to the head, just to hint further the criteria for the daterange will look like
Between [Forms]![formname]![startdate] And [Forms]![formname]![enddate]
where startdate and endate unbound controls on the form.

Brian

 

[Bloodrayne]

Nope!

Whatever I remembered, it wasn't the right thing - darn it!

So, I need to be briefed on the basics of doing things like this - from beginning to end, I'm sure some of it will look familiar - is there any handy links you could point me to?

 

[Brianwarnock]

I don't know any links but searches on this forum may produce answers.
I have knocked up a very simple sample that may help.

brian

 

[Bloodrayne]

Cheers, I shall have a look through that and see if I can pick up where I'm going wrong.

 

[Bloodrayne]

Works like a charm - I can see where I was going wrong now.

 

[Bloodrayne]

Another question along these lines, the report has two dates (one request date, one booking date) and needs both these to be shown on the report - which isn't that much of a problem (I think)

The thing is - the date booked should not be allowed to go over the entered date range, I'm looking for some kind of 'less than' command, does Access have one?

Thank you!

 

[Brianwarnock]

Typical criteria < > <> =

 

[Bloodrayne]

Superb!

Even managed to find the screen I was looking for... One day I'll last an entire work day without posting for help..

One day...

 

[Bloodrayne]

Not today though,

What would be the best way to go about setting up the criteria, so that it only shows values that are below the input value, and yet still show zeros, where appropriate?

<[forms]![Flight Report]![edate]

I thought that the above code would work, which it does.. to a certain extent... just need to get those zeros to show

 

[Brianwarnock]

Not sure I understand. If you mean that there are records without a date and you want to see those then Is Null on the next row of the criteria else further explanation required

Brian

 

[Bloodrayne]

Yup - well deduced!

Exactly what I was after, apologies for the lack of clairty...