Search results

Hi all, I have approximately 40 odd queries on my Access database and as this number is increasing on a daily basisi, I was hoping there was a better way to easiliy retrieve queiries relating to particular sections or people. I am aware you can group queries but for some reason the main...

I really need some help here please so would be grateful if anyone has an idea as to what is going on! :( I have 2 tables. One of the tables has 191 records and the other 221 records. The tables contain the same data and I need to know how to run a query to show which records are missing from...

Hi all, I would like to save the data generated from my query as a table. This will then allow me to report on that data much quicker as well as allow for me to share that specific data so that it can be used within another database. I know you can save the query but this this means the...

Hi, I have an Access database that contains the start and end dates of a permit. I have been asked to check if anyone with a valid permit also has recevied a ticket. Therefore I need to be able to identify from my list of tickets issued if they fall within the valid permit period. Can...

I have successfully managed to import a range fo text files on my new PC ( has MSAccess 2003 installed) but for some reason 2 of the files keep reporting errors. To complicate matters I have managed to import those files onto another colleagues PC without any problem that was installed at the...

I am aware you can use the BETWEEN command to report on a date range however I am unsure how you would actually add this to the query that I have below: Expr1: Int((DateDiff('d',[issue_date],[expiry_date])) As the problem with the above equation is that it does not on some occassions inlcude...

Hello all, I have been searching the web for help in importing data into Access. At present I have approximately 30 tables that I create each month. Some of these tables are replaced and some are apended. To help stream line this process can anyone please help me to create a macro, VBA...