Search results

Hi There I currently use an unmatched query in access that counts the number of records that meet the unmatched criteria. Sometimes this query will return no records. I need to use the results of this query in a following query that totals two queries together (the one mentioned above and...

Hi There I am using append queries to populate a results table using various imported spreadsheets. Some months there are two spreadsheets that could be blank they being Leavers and Starters. If these are blank I would like the append query to add a default record with 2 columns. The first...

Hi there Hopefully someone can help - I am sure this is fairly basic but I am a bit rusty because not used Access for a while and just getting back into it I have a table that collates 12 months worth of data and each month I want to add the current data to the latest field i.e. at the end...

Hi hopefully someone will be able to help me I am using VBA and querydefs to amend some queries that I have created. I have a table in which I have a list of names that I want to use for fields in these queries and i am opening this recordset and trying to get the code to scroll through and...

Hi I wonder if you could help me - I have a field in a database that is supposed to be a UK postcode. The problem I have is that some people have only supplied the first part i.e. say L1 or LE1 or NG20 and some have supplied the full post code. The data in this field can be from a length of 1...

Hi Is there a way of counting the records in a number of tables and then inserting the table names and counts into a table. I have a table with the names of all the tables in it as this is populated when I import from excel. The resulting table would be Name Count Table1 25...