Search results for query: *

My organisation performs a number of different collection services from a large number of premises. The most complicated situation I am trying to model involves a block of flats/ apartments / retirement home. In this scenario we might have 16 flats in 4 blocks of 4. Blocks 1 & 2 have collection...

Hi I have to have two tables for sites and master addresses, as the occupier of the site may change with time and we need to keep historic records. I have two forms, one based on the sites table and one on the master address table. When a user enters a partial address in the sites form, they...

My organisation provides a biweekly collection service for our customers, and I want to produce a calendar of collection dates. So far I have made a query that takes the collection code for the customer and produces a start date for the first collection in the next financial year. What I want...

I am trying to write a query that searches a table with address data based on criteria input using a form. The trouble is that if the field in the form is null the criteria in the query is "Is Null". I want to return all values for a field if the form in the form is null, i.e. the equivalent...