Search results

  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

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

    Count between 2 dates

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

    Query - Lookup/Query Repeating data entery

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

    Query returns 2 results instead of 1

    I am creating a database for a hyperthetical car hire company. A customer hires a car from and until a certain date. If a new customer decides to hire a car i want to generate a list of cars that he can choose on depending on the other dates from which other cars are hire from and until. I have...
  9. I

    Query problems - 2 values returned instead of one

    I am creating a database for a hyperthetical car hire company. A customer hires a car from and until a certain date. If a new customer decides to hire a car i want to generate a list of cars that he can choose on depending on the other dates from which other cars are hire from and until. I...
  10. I

    Query problem

    I am creating a database for a hyperthetical car hire company. There is a car table, a booking table and a customer table. When a customer books a car the cutomer ID is taken and the number plate of the car is taken. I have generated 2 lists. The first contains all of the numberplates...
  11. I

    Search between 2 dates

    I have created a database for a hyperthetical car hire company. I have a booking table, a customer table and a car table. If a customer books a car starting on one date and ending on another I want the database to generate a list of cars that are not being used at these times. I have worked...
  12. I

    Serach - Return

    I am creating a database for a hyperthetical car hire company. I have created three tables, customer table, car table and bookng table. The customer table is linked to the booking table using a Customer ID (autonumber). The car table is linked to the booking table using NumberPlate. The...
  13. I

    Table structure - transfering information

    I am creating a database for a hyperthetical car hire company. I have a table for the customer details, a table for car details, a mid table with current car hire information. I want to create a table for previous car hire information. Is there a way that i can transfer the details from the...
  14. I

    Count problems

    In the query if i am doing a 'count' it does not work if i enter any criteria. It works fine if there is not criteria (search)
  15. I

    Changing total cell to expression

    When i use MS Access help to search for my query i get this result: "Note: If you add a calculated field that includes one or more aggregate functions to a query in qhich you're calculating totals on all the records, you muct set the calculated filed's TOTAL cell to EXPRESSION How do i do...
  16. I

    Help me please

    I have 5 tables: 1. Student Information 2. Project Mid Table 3. Project Information 4. School Mid Table 5. School Information Student information is linked to both of the mid tables and both of the mid tables are linked to their corresponding tables (project mid table - project information...
  17. I

    Query - Search Engine

    I would like to create a query where I can search my selected fields on a particular field. However I do not want to do this in the standard way. I would like the query to appear in a 'search engine' type format (like a form but with a search). Is this possible????
Back
Top Bottom