Recent content by 0nyx175

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