Search results

I am using Access 2010

Hi, For this particular database, in query design mode I right click to bring up the menu, the click on "Show Tables" and nothing happens...no sign of the list of tables that normally appear to the right. This has only recently occurred...Could I have changed something in File..Options? Thanks Bob

Thanks all..i used isladogs idea with success...I will learn from the other info . isladogs idea

I have two tables joined by StationID. In a query that shows which companies (stations) have a link (RPCustomerPoNumber) to field in the other table, but I only want to see that company name once. The query is unbound. SELECT DISTINCT tblRepReport.StationID, tblStationData.[Station Name]...

Hi To answer plog: The employees use MYOB for sales etc The database is used in conjunction for tracking possible sales, as a database of customers newsletters, calculatinng freight etc... I have downloaded a spreadsheet of products etc from the MYOB unfortunately there are many products...

I have an SQL query (Query1) that gets its data from two different tables...works fine. SELECT tblProduct.ProductID, tblProduct.PartNumber, tblProduct.Product, tblProduct.Purchaseprice FROM tblProduct UNION SELECT tblProductsMYOB.ProductID, tblProductsMYOB.PartNumber, tblProductsMYOB.Product...

Thanks Pat I have done as advised and all s well

Thanks.. works well..Excuse my misunderstandig of your previous comment

Hi I want any all companies that have a serial number associated with it, but only one instance of each of these companies

Hi I want any all companies that have a serial number associated with it, but only one instance of each of these companies

I have a need to limit the number of times a company comes up in a query result. I have two tables: tblStationData, and tblSerialNumbers I have tried SELECT DISTINCT tblStationData.StationID, tblStationData.[Station Name], tblSerialNumbers.SerialNumber FROM tblStationData INNER JOIN...

Hi Mark Maybe I did not explain clearly...your solution works fine for that table....I have another table...that requires a similar solution tblESSRates tblESSRates I was trying to change the KG field of the previous example to suit the OriginCountry field here...any thoughts would be...

Hi Mark I have used your code successfully...What would need to change if the field eg KG was a text field instead of a numerical field?

I have managed toimport my spreadsheet in to replace your existing table (my table ranges from 0 to 300KG) and your form is working

Excellent...above my level of VBA but seems to be giving a result for a KG twice that entered eg I enter 4.5 in the Kg box and 2 in the Zone box i get a result of 133.3 which is the number for 9KG?

Hi MajP, Managed to transpose the spreadsheet OK (learn something every day). In my instance where the user is quoting a possable sale and wishes to enter a product and get a freight cost for that product, do I need the weightstart and weightend? It seems that the requirement is one need at a...

Thanks for all replies.. see how I go Have to fit this into other requirements

Thanks Mate, I will wrap my old mind around this (80yrs). seem the solution

Thanks mate, I will digest this...2.75 is to round up

I have a table imported from Excel...(Screenshot below) It relates to freight charges and I am required to programme vba to allow the user to enter say 2.5 Kg and Zone 4 and have the answer 109.75. I have no idea so am looking for any ideas which will be much appreciated Thanks Bob KG...