Queries in Access

Can Anyone help me with following two queries asap.

1) Show details of services that have occurred during the last 6 months. Be sure that upcoming services do not appear in your output. You should show the rego number, make and model of the vehicle involved, as well as the date of service, description of the service carried out and amount due for the service. Order the output by Date of service. Do not hardcode dates into your query.

2) List details of Customers who do not own a Ford. Show all customer details. Note: it is not possible to correctly answer this question using a join query. To test your query, make sure you include at least one client in your sample data who owns both a Ford and another non-Ford vehicle.

Its a database for a motor car repairing company. Pls help asap...I am unable to write the correct queries for these two
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!