Search results

I have a table with data as the following ID text CreatedDate CreatedBy 1 my first entry 01/01/2017 Jim 2 my second entry 01/02/2017 Kim 1 my third entry...

Cracked it myself - SELECT Table.* FROM Table, (SELECT DISTINCT [Tens]+[Ones] AS Factor, 100*Abs([Deca].[id] Mod 100) AS Tens, Abs([Uno].[id] Mod 100) AS Ones FROM MSysObjects AS Uno, MSysObjects AS Deca) AS F WHERE F.Factor<CountOfFruit ORDER BY ID;

That works perfect, thank you - BUT I have several entries that are over 100 - and it looks like your query only goes to 100. Can it go higher - then you've cracked it :)

I have a table with data Col:1 ID Col.1 1, 2, 3 etc Col2 Fruit Col2 Pear, Apple, Orange Col3 CountofFruit Col3 2, 4, 7 This would bring back 3 rows with the data above. I want to increase the row count based on the countofFruit Therefore, it'll have 2 lines for ID1, 4 for ID2 and 7...

It's the UK postcodes list - but it doesn't include an update field as far as Im aware. Haven't tied anything yet.

If it makes the code easier - I could import the CSV as a table

I have a table with a large dataset, with 5 columns which data can change (the first is a unique ID that doesn't change). I am given the same dataset in CSV that I can then import as a linked table which may have changes What Im trying to do is loop through the existing dataset and update those...

Hi - thanks for the update - I see now. It works really well. Can I ask why you use only partial data from the API server and pick up most from the Postcode database? Hence when it comes to Lond and Lat it would be best to get accurate data instead of the middle ground downloaded data. Only...

It works ok - but there's a big BUT - there's no Road names. Also, you would need to update the data set every new release. Therefore, I was hoping google API might get live data.

oooh - looks promising - thanks - will post update after looking

I have searched and searched the internet and not found anything that I understand and helps. I have an access db that records addresses, in several fields. i.e: House number, street, county etc. Currently users complete this manually on a form and data inconsistency and accuracy is high. I...

I am. Just wondering if I was doing something wrong or if it was impossible. Unless anyone can suggest a work round

I have a database (sql server back end - access front end) I use vba to open an excel sheet that is already linked to a query in the current DB, when I try to refresh, I get a DB is in a locked state by Admin etc Is there a way to refresh this sheet with passing the data to another DB...

I have a table with start and end dates. I need to build a query to show the next 6 months everything that has: - already started - going to start - that has not ended Then I need to show each line of what calendar week it fits under if it's live. Yes, I am aware i will get dup lines - but...

Hi - thanks - I've messed around with this so much I might have written it incorrectly. I have a path that is always: C:\Users\Jim\ I then create a new folder called Test I am then trying to get: const spath = "string etc" to say : C:\Users\Jim\Test\

Didn't work - I get a compile error

Hi Im trying to declare a const I have declared Dim strPRX as string. strPRX = "Test" Im using: Const spath = "C:\Users\Jim" & strPRX & "" I Get: spath = C:\Users\Jim\& strPRX &\ What Im trying to achieve is that spath = C:\Users\Jim\Test\ Any help please

Hi - Not sure if this should go under 'General' I'm after a sample DB for Access 2007. That can help me schedule items. I need something with dates across the top with Categories down the side. But each Category could have more than one item under the same date period. Something like this...

Due to other factors, I've had to re-do my query. Therefore, now two new queries One query with the Person and TableIn and then Created another new Query adding this Query and then adding in TableOut. Therefore, Im not sure how to do your latest suggestion. Could you please elaborate on my new...

PERFECT - But one more thing please - If there was another field on TableOut called TYPE (text only) how would I also include this next to DateOut which will have data next to each date