Report Format - RecordSource Query

[mousemat]

Hi

I have developed a small application whereby a booking form is created from fields on a form.

My problem is that I am unable to get 4 fields to format correctly. The fields in question Date/Time fields and a currency field.

The information from the form is pulled via a querydef to include the hirers address on the form.

I have tried to set the format in the report but to no avail. Is it because I am using a query def?

Heres the database to have a look at. Any help would be appreciated

 

[ansentry]

Open the form FrmHallHire2 and click the preview report button, you will see that it is working fine.

If you open up the rptHallHireForm2, and go to the "Event" control you will see how what I had to do to get the data accross from the form. As the cost is not a calculations why is it not stored in a table?

Also what happens it Mr Jon Smith wants to hire the hall a second time?

...just my 2 cents worth.

I have not changed your form, query or report just created extra ones they have 2 at the end of name

 

[mousemat]

As the cost is not a calculations why is it not stored in a table?

Also what happens it Mr Jon Smith wants to hire the hall a second time?

Thanks, thats great, works a treat.

The Event Cost is a calculated field and is derived from the number of hours mulitiplied by the Hours rate plus 2.5 hence the reason it isn't stored in a table.

If Mr Jon Smith wants to book the hall again, I just creat a new record via the form. The form will be a DataEntry form.

Thanks for your help.