Search results

Hi, we get an excel spreadsheet from our suppliers for the silicon wafers they supply us, it contains debug and failure info, and i need to import some of it into our database. my issue is the worksheet names are #01 - #25 and i cant get access to see these worksheets i use...

Hi, im trying to get a count of the unique customers in an access 2010 database after some research it seems i should be using SELECT Count(Distinct [Customer]) FROM [tblMain]; but when i use this i get Syntax error (missing operator) in query expression 'Count(Distinct Customer)'. i have...

Hi, this may take a bit of explaining so please bear with me i have been tasked with creating a sales forecast database for use by our sales reps and production coordinator and i seem to have run into a snag. firstly our company does not use the traditional calendar (dont ask) so i have to...

I have been hiding here for some time but need to ask a question so thought i better say Hi first (its only polite) so...Hi :) im from Scotland, been using Access for about a year (i inherited it when our Access guru departed for pastures new)..mostly self tough with a couple of books and a DvD...