Recent content by icemac

  1. I

    Is this database possible to create?

    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...
  2. I

    Count of records

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

    Query help date format

    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?
  4. I

    Query - Extracting customers between two dates

    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?
  5. I

    Repeating Data

    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?
  6. I

    Repeating Data

    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...
  7. I

    Count between 2 dates

    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
  8. I

    Count between 2 dates

    Here is a sample of the database
  9. I

    Count between 2 dates

    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?
  10. I

    Count between 2 dates

    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...
  11. I

    Count between 2 dates

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

    Count between 2 dates

    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.
  13. I

    Count between 2 dates

    This does not work it never returns any figures
  14. I

    Count between 2 dates

    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
  15. I

    Count between 2 dates

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