Generating a report based on a number value

[Galphanore]

I am trying to get a report to show a number of records in the detail section based on a number value in a form, in the attachement I'm trying to get the report Main to show four rows when the Days text box in the form Main has the number four in it, for example. The first row should display today's date in the Date box, second should show tommorow, third the day after and so on. Is there any way to get it to do this?

 

[WayneRyan]

G,

Just tinkered with it a bit. Had to use a QueryDef to take advantage of
SQL's Top predicate.

Wayne

 

[Galphanore]

Thanks, but I'm trying to get it to dynamiclly generate it without havinig to pull the dates from a table, I don't want to have to make a table with all the dates from now till the end of time

 

[Rich]

If the dates don't appear in your db records then why would you want to show them ?

 

[Galphanore]

What I am doing is creating a sign in roster for a contact. It shows the times they are supposed to sign in, and shows when they are not, based on whether it is a weekday, weekend or holiday. So I need to be able to generate a report that shows the next 60 days, for instance, and then has blocks for them to sign on each weekday that isn't a holiday. The holidays, however, are in a table.

 

[Rich]

Easiest way is to use a table and fill it using vba with temp dates that you want to display

 

[WayneRyan]

G,

Fair enough, no tables, no seeming purpose ... but interesting.

HTH,
Wayne

 

[Galphanore]

Thanks! That's awsome.

 

[Galphanore]

Is there any way to get it so that I can reference the dates in another field? I want to have lines next to them that use the following for a control :
=IIf((Weekday([lstDates])>1) And (Weekday([lstDates])<7)," ","Weekend, No sign-in.")