Search results

I need to create a database for students going on work experience. Each of the students will have a rating from 1-6 depending on behaviour, effort and attainment. Each of the work placements also has a rating from 1-6. Each student chooses 6 work placements that they would like to attend (one...

I have created a query that returns x number of records. How can i count this number (x)?

In my BookingTable I have a StartDate (Format: "dd/mm/yyyy"). For every start date there is a CostOfBooking field also in the query. I want to show a list of all the current StartDates that occur in this month of this year and the cost of that booking. How can this be done?

My customer searches hires a car between two dates - StartDate and EndDate. I want to build an expression that searches my database for all the customers currently using cars (using cars on the day of the search.) How can this be done?

I had to delete the forms to make the database to make it small enough to post. Is there anyway of not having to enter the data twice or do i just ahve to enter them in the search boxes?

Here we go again i have another problem. I am finding it very hard to explain my problem so i have attached a copy of my database: Have a look at NUMBERPLATE OPTIONS in the booking table. When you click on this field you have to type in the END DATE and the CAR TYPE to generate a list of...

O im not worried im learning alot from the forums. The little example helped loads and i know now what i was doing wrong. Thanks everyone for helping me with problem. Iain

Here is a sample of the database

Im sorry but im a bit of a noob when it comes to database design and not exactly sure what you mean now lol. Can someone PM me their email so i can send them them database for them to have a look at?

Basically i want to count the number of days between two dates. Thats it. I have a field in my booking table called Count of days and when i type in the two dates "Starts Date" and "End Date", into the fields "Start Date" and "End Date" (also in the booking table), i want the number of days...

the file is too large can you post your email or PM to me.

icemac can i send somone a copy of my database so that you can have a look at it. this way it might be easier for me to describe my problem to you.

This does not work it never returns any figures

the like expression simply searches through you table to find any values that you type into the "search box." So if i type in 01/11/2006 and there are any dates that match this then it will be displayed

what if i want to do this: DateDiff("d",[SEARCH FOR START DATE]![Start Date],[SEARCH FOR END DATE]![End Date]) this doesnt work

DateDiff («interval», «date1», «date2», «firstweekday», «firstweek») i understand what you enter into date1 and what you enter into date 2 but what do you enter into the other ones?

I have 2 dates. How do i count the number of days between the two dates?

i dont think i am explaining myself very well so here goes again i have a car type filed and a numberplate field. When i click on the number plate field a search box appears. Here you type in the name of the type of car "sports car" (for example) and generates me a list of all the numberplates...

I am creating a database for a hyperthetical car hire company. I have a field with a lookup/query. The data that this query searchs for is entered into my table/form already. Is there anyway of avoiding repeating this data twice? Iain

Thank you that was lots of help