Search results

Hi guys. I've been wracking my brains all day with no luck. I have the following data Account number Forename Surname 1 2 3 4 5 1234567 bob jones F A F F F 2233111 Sid Roberts A F A F A These are an individuals voting...

Hi guys, I have a query in my database called "Open Date" which is a date formatted field when imported as DD/MM/YYYY. The criteria is set to: >=#06/04/2014# And <=#05/04/2015# The query works just fine. My customer has come back and asked for the way the date is displayed to be in the...

Hi guys, I have the following table NINo - AccNo - Saving AAAA - 1234567890 - 10 AAAA...

Hi guys, I've got a database with an 'address 1' field. Sometimes if it's just a number, excel formats the field as a date. Is there anything to check the field to identify any that are showing as dates as opposed to just normal fields. For example identify all customers who have some...

Hi guys. I’ve got the following information: New_Customer_Table Account Number Title Surname Address Post-code Existing_Customer_Table Account Number Title Surname Address Post-code I’d like to produce a form to add new records into the new_customer_table and if...

Hi guys, I have a table in excel with the following data ACCNO Address1 Address2 Address3 Address4 Address5 Postcode I import it into a table called address which is fine. I then go to put it into another table (customer_register) using an append query but it kicks up a fuss saying it cant...

Hi guys, I have the following information in a table: NI Num Subscription Balance NI # 1 17 36 NI # 1 50 500 NI # 1 100 0 NI # 1...

Hi guys, I’m having trouble with append queries. I have the following tables: Customer Number First name Surname DOB Post-code A company will occasionally send us large updates to post-codes which will show records and new data. It’s not as simple as replacing the entire...

Hi guys, Firstly apologies if I’m in the wrong place. I’m reacquainting myself with Access and have created a simple database for the logging of purchases through a store. I have the following tables: Customer Customer_number First_name Surname Item Item code Item name...