Search results

i think people are over complicating things? You just want to count all the 1's right? Total the column, the divide it by how many there are = Sum ([Column1]) / Count ([Column1]) the 0's are just the number of 1's subtracted from the total amount. or for letters use the domain count...

I need to append a query, but only for unique fields... I seem to have a problem where it appends data over, even if it is already there? I need it to check for a unique "OrderID" before moving it over... Any help is appreciated.

I too am looking into this sort of process, I have been told to look into the DMax function.... in which I am currently trying to figure out.

Is this possible? if so how would I apply that into access? I only need this at table level, but if this isn't possible - i.e. through a query, what is the best way to do this and how??

Thats all very well mark, but I don not want to buy anything... I'd rather figure it out for myself. Postcodes aren't inaccurate, else we'd end up with missing post... there must be a way for google to read Post Codes and street addresses from KMLs...

thats what I was saying... Postcodes work... but, the only guide I found in constructing a kml file for google needs coordinates, and I only have postcodes? Also how would I export my database into such a construction... i.e. defining my own tags to match those which google use.... and also...

thats not 100% true.... searching a postcode in google goes straight to the street... however it does only that unless you put the company name in there as well and they have registered for google mapping pinpoints... for example: searching for "Digiprint BA1 1QU" goes straight to it -...

http://code.google.com/apis/kml/documentation/kml_tut.html#placemarks I followed that tutorial on the google page, and it looks like KML files for google earth require longitude and latitude... but not post code reference?

ah that's interesting, would I just export the postcodes into some sort of XML data file? how is this set out - is there a page for this?

I've seen forms before where they can show you a google map using the address data in the table to display the location however, the ones ive seen, (about 4 or 5 different versions), only do it one by one. I have a list of 1000 Postcodes and addresses, I need to export a google map with them...

The OrderID is not allowed to be repeated, as the orderID needs to be unique during each append. How do I try and get it to identify new order IDs? Its a primary key in the table it came from, but not the one it's heading to.

I am having trouble with an append query and I have a theory which needs to be translated into access lingo... basically to only add things to the list if the ID isnt already there to avoid duplicates? Something like: Append: OrderID, OrderType, DescriptionID, to: tblInvoice, Where...

I use an appending query which sorts out ordertype= 3 and adds them to tblInvoice, trouble is, it worked for 1 record, but when i added a second record it added the first one as well, giving me three records when there should be 2... and the third one added the previouse 2, giving me 6 records...

Re: Continuous form problems - DSum problem... By using that, it has worked, great stuff! However I come across a problem for my next stage... adding them up to subtotal. I have the boxes: DiscountTotal and SubTotal in my main form (the rest are in the sub form) Now when I go to produce a...

I have a continuous form, (a sub form on a main form). I run the following code on the form to simply work out the discount into two fields into the form, "Discount" and "CalcDisc" Private Sub Form_Load() Me.Discount = Nz(Me.Price * (Me.DiscPm / 100), 0) Me.CalcDisc = Nz(Me.Price - Me.Discount...

Hi kenn, thanks for the suggestion but I did try that a long time ago but ran into problems, where I worked everything out in the form in the control... unfortunately I was told it wasn't very good at working out sums (which explained why it didnt work when I first tried it) and was told its...

The orderDetails is where the price is entered... they are totaled on the form Description. Description contains the subform orderDetails

and now I get the problem "Invalid Use of Null" for descriptionID

yeah the problem Change has is it's delayed :S... like if I entered 10, Price would still be 0 When I entered 15 in the next field it would change to 10 and when I entered 5 in the next one it would change to 25!?

as I'm typing... theres OnChange which i just discovered and am trying to figure out