Search results

I calculate the number of days between two dates and now I want to figure months and years. Any suggestions?

If you mean you want the form to open with the fields blank ready to enter data you can set this by going to the particular form's properties and clicking on the Data tab then set Allow Additions to Yes.

Rich & Graham T Thank you both, your help did the trick. To others who posted, thank you also. I appreciate your contributions.

Is there a way to count the number of Groups in a query or for that matter a report?

Can you use the following and when you want one date type the same date in for the beginning & end? Between[beginning date] And [ending date]

Don't worry I've solved my small problem. I will no longer work on db's late at night. A simple grouping/footer in the report has done the trick. ;)

Thanks Pbaldy. I've tried your suggestion but it does not return the results I'm looking for. First I want the query to group the years separately. I've added DateYear which shows the year eg 1981, in an attempt to make the criteria easier but I haven't had any successs. So if anyone knows...

I would be honoured if someone thought my db work was worth the effort and used my work themselves. But alas my design skills could realistically be described as undeveloped. Maybe one day when my skills bloom (that's a good one) I will be able to contribute as many of you have and continue to...

"#Name?# is printed in the unbound text box that I created which is supposed to show my selected date. I guess I am doing something wrong when I type the parameter name. I am selecting the Start and End dates using a form.

Yes the form is open when the report is run.

Thany you Thanks Tony, I compiled it in 97 and found one tiny piece of "hopefully" stray junk code & now it has converted ok.

When I use, [Forms]![sale goods by date form]![txtFrom] as the parameter the report prints #Name?

I want to use Access 2000 to open & save a db which was created in Access 97. When I attempt the conversion access tosses up a Compilation Error. Does anyone know what would cause this or is this just one of those MS thingies? On first glance it seems as if after clicking "OK" I can use the db...

Thank you for your replies. I think Graham T has what I need although I can't get it working just yet. I am using the following in my query because I use a form to enter the "From" and "To" dates; Between [Forms]![sale goods by date form]![txtFrom] And [Forms]![sale goods by date...

I am using two text boxes on a form to set start & end dates for a report. I wish to print the date range on the report. Any hints?

I am still working on my rainfall db (as time allows). I have the following fields in a tbl. 1. Precipitation 2. FallDate 3. rainID This is working ok. I am using Mile-O-P's calendar on a form to view reports with date ranges. This will give me all rainfall between any two dates. What I now...

I need to constantly view data from the current date back to the previous 1st July. I know this could be done with a parameter in a query but I would prefer to set the query criteria and just click on the report.

I am using this in the "on click" to enter the date via the calendar; Private Sub cmdDate_Click() DoCmd.OpenForm "frmCalendar", , , , , acDialog, Me.Name & ";Date" End Sub This is on a sub form called Events SubForm. This will work if used with the sub open only but as the sub is run off...

M-O-P I thought I would use your calendar on another db to enter just one date in a date field. The date field is on a sub form and it workd ok when I edited the form to add the button etc. however when I opened the main form & clicked the button I got an error telling me that the sub form can't...

Thank you MOP (patience is a virtue) "One small step for man" one Quantum Leap for me. With the date range selection Form open and then running the query I can view the selected data. How should I go about getting this data into a report?