Search results

well in my table i have 5 number records and i want the top in each but i have created a query out of the sub queries for each which gives me a list of the relevent ones but the list is rather long thanks tho

how do i modify that for multiple entries i have this but it jhust brings up bacically every record in the list SELECT TOP 1 NumberData1.[Number 1], NumberData1.[Number 2], NumberData1.[Number 3], NumberData1.[Number 4], NumberData1.[Number 5], NumberData1.[Number 6] FROM NumberData1 GROUP BY...

i have a list of numbers and for my analisis i need to find out which one appears the most often in my table i have tried to figure it out. your help is appreciated chris

I want to create Graphs inside My Reports the graphs are based on a query that has questionnaire results in it currently we have a report that lists the percentages these are the calculations from the report it takes a count of the monitoring period (which is entered by the user) and then works...

oh that's excellent yes that does solve the problem thanks a lot

We have a rather large amount of information in our access DB we use an automatic update macro thats activated by the user via a button this macro activats another macro which Uses the Transfer Spreadsheet function to transfer files from EXCEL into a TABLE call it (Imported FRom Excel Trimmed)...

Sorry Confustion there, the macros run append and delete Queries which Take the information from The excel files and input them into tables withiun that access DB which are then linked to a main filestore access DB hence updating this main file store. the errors i'm getting i would presume to...

I have a number of excel files that are regularly updated via a macro into an access database, now these dont work sometimes, three of the tables come up with 3 errors one just makes the macro fail One Has A numeric field overflow one has an external table not in expected format using the same...