Search results for query: *

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

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

Hi Could anyone help please? I have 2 tables: TblVehicles Reg (pk) Model Colour TblReservations ID (pk) Reg ResStartDate ResEndDate The tables are joined by the reg fields. I have an unbound list box and the row source is the following SQL which mainly works great: SELECT DISTINCT...

Hi Would someone kindly help me with this query problem please? The records in my table have a start date and end date as if they are reserved for a period of time. What I want to be able to do is query the table to only show me records that are not reserved between the dates I specify. For...

Hi all I know what I am trying to do is simple but I just can't get the expression correct! All I want to do is have a fields background colour red if there is no data in it and change to white when data is entered. The field is called Phone and is text format. Thanks for any help

Hi all I have a report that details various types of analysis based on queries and all is fine but I am having trouble with one and need some advice on how to go about it please. What I need to achieve on the report in a table like format is this: Column 1 = Resolved by. The rows need to list...

Hi I have 2 tables, each have an autonumber as the primary key. Different data will be entered into each table by different users and this all works fine. But On occassion, I will want to append the data for a record from tabel 1 into table 2. Currently this will cause a problem as it will...

Hi all I am having some trouble with an append query and would appreciate any help. I have 3 tables for potential customers Potentials (PK) Calls Appointments All tables have a ContactID field (autonumber) and they are all linked through this. And 3 tables for existing customers Existing (PK)...

Hi I am very new to coding so please be patient with me! I have a form called AM Contact Mgmt that reads data from a table called AM Clients. The table AM Clients contains 3 fields: Phone - text format Mobile - text format Preferred Phone - number format On the form AM Contact Mgmt I have 4...

Hi I am not very good when it comes to writing code but I assume this is a very simple question. I have a report and in it's controlling query I want to define that if a field is empty then the report should show the text N/A in that field. For example, the report may look like this if the...