Search results

The vote column values are input by the user. Could you think of a way to restructure which would allow me to output in that format?

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

I've narrowed it down. If i run criteria as >=#06/04/2014# it runs fine but if i run >=#06/04/2014# And <=#05/04/2015# as criteria it doesnt return anything. This is only when it's formatted

SELECT Format(Table.[Open Date],"yyyy-mm-dd"), TABLE.Account FROM TABLE GROUP BY Format([Table].[Open Date],"yyyy-mm-dd"), TABLE.Account HAVING (((Format([Table].[Open Date],"yyyy-mm-dd"))>=#4/6/2014# And (Format([Table].[Open Date],"yyyy-mm-dd"))<=#4/5/2015#));

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

I was thinking something more along the lines of a cross-tab query but can't work it out. The report acts like the query in that it does the folowing: NINo - AAAA 1234567890 2222222220 9878978979 4554545454 I cant mail merge the above It doesnt matter which account for AAAA is account 1.

Here's the visual basic code I used (or a variation of) for one of my databases. When the user clicks 'submit record', the form will check that the boxes that should be completed are completed Private Sub Command37_Click() 'Define error Dim error As Integer 'If 2009 tax box is empty and...

Format (date, "Short Date")

In the past i've used data validation visual basic macros connected to the form so that when you press submit it looks at the fields and makes sure you haven't completed any you shouldn't based on those you have completed. Let me know if this is something you're interested in and we'll take a look.

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

worked like a charm - thanks.

Sorry, that wasnt formatted well: Name, address 1 Bob smith, 11 Smith street John Jons, 12 Acorn grove Hal Jordan, 14-Dec-2013 Wade Wilson, 29-May-2013 Nathan Summers, 112 Bradford street

Okay, here's the table: Table1IDNameAddress 11Bob smith11 Smith street2John Jons12 Acorn grove3Hal Jordan14-Dec-20134Wade Wilson29-May-20135Nathan Summers112 Bradford street I need to make sure the addresses aren't accidentally formatted as dates by excel and then imported into the database...

Some fields are going to be correct and some aren't - wouldnt this only pick up if the overall field in the table is a date as opposed to one particular entry

just need to check if a field fits the following format: "dd-mm-yy" If it is down as 19 smith road then thats fine but if it's as 01-Jan-12 then i need to know

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

Dont worry about that.. i've stripped this down to it's most basic form so i could put it on the forum. Essentially, i'm inputting customer purchases onto a database and would like some validation so that if we have had a purchase from them before, it will pop up with their address on the...

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

Sorted with the following query: NI number Subscription Balance Group by Sum Where >0