Search results

As a follow up to my initial question, I spoke to a friend who suggested that the only way to resolve this was by using a Union Query which tied together the expected invoices and those that had arrived. This was a great solution and allowed me to develop a form which shows the expected...

Doc Man, Thanks for your response, I have been thinking this through and if I understand you correctly the query would report shipments with no invoices. My problem is that each shipment may have any number of invoices (from 1 to 20) and every shipment is different. I am trying to design a...

Pat, Thanks for your reply, I have tried that and it does not seem to want to play. It still insists on missing shipments which show in the Query out! Kind regards John

Have you thought of using Switch? Switch([age]<16,"under 16",[age]between 16 and 20,"16-20",[age]between 21 and 25,"21-25"....True,"Unknown") It can be easier than all those iif's!

Hi, I have been working on this issue for several weeks without success, any assistance would be much appreciated. My database tracks the invoices related to shipments, each shipment can have as many as 20 different invoices raised against it, but not all shipments have the same invoices...

Rabbie's solution is correct, but you should be aware that the command "Date()" when used on the 29 October 2008 would actually gives you a date and time of 29/10/08 00:00 hrs. If you start to mix this with times, say 29/10/08 20:00, any time after 00:00 hrs on the day in question would be...

Maxmangion, Thanks for your rapid response, Unfortunately I'm not sure this will help as at the moment the Invoice Table is linked to the Shipment Table by the shipmentID. There is no list of expected invoices! I believe there needs to be a list of the invoices that should be expected for...

Hi, I'm developing a database with which to manage shipments of materials. This process involves a large number of invoices changing hands, some incomming and others outgoing. I normalised the DB and have a table called invoices which has the following fields; Invoice ID (Auto Number)...