Recent content by nunan

Thanks I appreciate your help, where do I place this?

Hi Thanks for the reply. I have tried this in the tables and forms associated with the action but it doesn't work. The data is entered through a form, when the members name is added, it takes an operator of 'mem' and adds the next available number from the counter table creating a full...

Hi I have used the following code for a number of years with no issue an initially, the data for this database was imported from excel with unique ID numbers already listed so I just had to set the counter to carry on from the last ID number which was over 1000. However, I am creating a new...

Hi PHV Thanks for your quick response. I had to change it slightly but this seems to be working perfectly now (fingers crossed), thank you sooooooooooooo much that has been driving me mad, I can now sleep!!! SELECT Reg, Colour, Model, ChargeGroup FROM TblVehicles WHERE Reg Not In (SELECT Reg...

Hi PHV I wonder if you can help with this please? When you originally answered my problem, I changed the code slightly so that dates could be entered through a form so I have the code below: SELECT Reg, Colour, Model, ChargeGroup FROM TblVehicles WHERE Reg Not In (SELECT Reg FROM...

That worked perfectly and I learnt something new, thanks!

Thanks PHV, I will try it later

Ah sorry, my mistake! I have a field in a query who's criteria requests a date: Between [Enter Start Date:] And [Enter End Date:] Then I have 2 expressions in the same query which grab the dates entered and insertit them into new fields: PeriodStart: [Enter Start Date:] PeriodEnd: [Enter...

Hi Can anyone help me please? I have the following expression in a make table query to return the required date. However, when the date is inserted into the table, the data type becomes binary which means I cannot append it to a field in an existing table which has a DateTime data type. Ch2...

Perfect as usual! thanks PHV

Hi there Could someone please tell me what I am doing wrong? If have 3 fields in a query that calculate values from various different places, then I have a fourth field that make a final calculation based on the values from the previous 3 fields. The problem I am having is that one of the 3...

Hi Could anyone offer some help please? I have a form FrmReservations. On this form is a listbox AvailListBox running an sql query which finds data from 2 tables TblVehicles and TblReservations based on a date range which is in a subform FrmReservationDates. The sql for the listbox is: SELECT...

PHV you are a genius, thank you very much.

Thanks PHV I will have at look at this tonight and let you know.

I have tried changing the join type a couple of times: This one doesn't make any difference: SELECT DISTINCT TblVehicles.Reg, TblVehicles.Colour, TblVehicles.Model FROM TblVehicles LEFT JOIN TblReservations ON TblVehicles.Reg=TblReservations.Reg WHERE (((TblReservations.ResStartDate) Not...