Search results

It does indeed.. cheers again, just working on a pop up calender and a button to open the query. Never used forms for much more than a nicer way of displaying table data, I know see their true power...

Ahh, I see, brilliant. I think you have just opened up a whole new world to me.... Cheers!

Can anyone help with this...? I have 3 queries all of which filter the results by date. I do this by setting the date field to WHERE and entering >[StartDate] AND <=[EndDate] as criteria StartDate and EndDate don't exist so when I run the query it pops up a box and which asks me for the...

Hi, can anyone help me do this... In my products table I have fields such as Bulletpoint1, Bulletpoint2, MainDescription etc. Each holds part of the product description In a seperate table I have my description templates with placeholders for the bulletpoints and maindescription. for...

Works a treat! Cheers!

Rabbie, that's just what I need. I was looking for the function IF, didn't cross my mind that it might be IIF..... I'll give it a try now. Bob, I think my data is set up as you say, the 2 bits in code I put in my original post are separate tables. Didn't realise you could use IF in queries, I'm...

Whats the best way to arrange my data for the following, and can a query do it or do I need to use VBA with an "if" command? I have the following data in my products table.... Products Courier Weight (g) Guitar Case DHL 700 Guitar Strings Royal Mail...

Cheers fellas! Been playing with queries, not update queries yet but that sounds like the answer I'm looking for. Thanks again, Dave

Hi there, and sorry for such a stupid question.. I'm just making the change from excel to access for my business. Most things seem straightforward but I can't seem to paste a single value into multiple records. For instance, I have a couple of hundred records. I add a new field. The first 70...