Search results

Now I am confused!!! I would probably need to query both of your suggestions...

Thanks! - I will crawl under my rock until I get my head around it!

Hi Galaxiom I am struggling with a query. I am drawing info from tblWindeed.streetname. I need to include all records that have a partial match. For example the street name is John Wayne St. I need all the records that have "John" or "Wayne" to be included. I cannot specify the text every time...

Well, I have learnt more about databasing in the last two weeks than the previous twenty years! Its all about NORMALIZATION! Get that right and most things seemingly will fall into place. So, here is my question: I have 3 sets of similar data (all about municipal stands and their related...

Hi Galaxiom, you need to break that down for me!! That was way above my grade! Thanks in advance. (feeling very dumb right now)

Let me clarify - Excel spreadsheets! Not tables..

Because my input data is coming from Excel tables that are being updated regularly, I have linked to those excel tables. The source data is in multiple tables because they are arranged by a billing cycle. I hope that makes sense. Regards

CJ London, I have made great strides! So, I have 11 linked tables, each the same, but dealing with different suburbs. I would like to run a query across all the linked tables looking for, as an example: all erf numbers on Smith Street. Smith Street could be in multiple suburbs. Regards Peter

Thanks CJ_London. My head has been spinning like a top since early this morning! I hav managed to implement a lot with that bit of help. I will have more queries later! I am trying to understand why some records are not pulling through (missing info in them) and on the Difference calculations in...

So tehNellie, did alsheron come right or did he drop off the radar?

Trust a newbie to confuse it from the start! tblVenus contains data(fields) that needs to be verified against fields in tblAudit Here is my query in English: Match tblVenus.Mun_stand with tblAudit.ERFNumber Diplay value of tblVenus.Quant and value of tblAudit.Toilets Calculate and display...

Please!! What happened with this? Did alsheron come right with his DB? THis thread just came to an abrupt stop! |I was following it with great interest..

I am a newbie to access, so please be gentle! I have 2 excel tables. One has about 148 fields and the other has 175. There are 5 common fields in the two tables Mun_stand = ErfNumber Mun_strno = StreetNo Mun_strnme = StreetName Mun_subnme = Suburb Quant =Toilets Of...

I am a dabbler. I know very little about Access and hope to learn a bit! I hail from South Africa which is at the very bottom of Africa!