Search results

Hi all, I have a problem to calculate the average length of buying any product for each customer. The way that I need to calculate this is to find the length based on payments for consecutive months. For example, I have a table called tbl.transactions with the following fields. For a customer...

Hello, I have a big table with different dates and some customerids. For example, date, customerid 01/10/2016, 100001 05/09/2015, 100001 03/06/2013, 100001 01/10/2016, 100002 05/09/2015, 100002 05/09/2015, 100003 03/06/2013, 100004 03/06/2013, 100005 The sequence of dates is random, so there...

Hi everyone, I have a small problem for which I have found a partly solution. I have a transactional history of purchases and I'd like to find the average time between purchases for each customer. For example, my table1 looks like this: id customerid order_date 1 1111111 03/02/2011 2...

Hello, I have two cases here with Strcomp function and I'll need your help. When I compare two strings using the above function, I get values as 0, 1, -1. 1) My first case is for the 0 values. I can normally get this even if I have two strings which ones is lower case and the other proper...

Hi, I have an Access file which is around 1.2GB of size. The version that I am using is 2010 Access. I have a database that I imported it from a csv file with no issues. Once I simply run an update query or any query that modifies the data and, then, try to compact/repair the whole file, then...

Hi, Probably, this is something silly, but I need to understand how to solve this. I have a title field for which I wanted to replace all the "N/A" to null. I used the replace function as =replace(title,"N/A",""). This made those records as null (as expected). However, if I run a selection...

Hello, I am trying to clean first names but there is such complexity that I cannot do it in a single query. j. b john john john j j. John john j john, john, peter j, john john j,john In all different examples, I want the output to give me "John". So, I need a query to remove...

Hello, I have a problem importing a file with around 3 million records. I get a csv comma delimited file with no quotations from an external source. It contains consumer data with demographics and personal details. However, the address field contains commas (but not all records). This means...

Hi All, I was wondering if there is someone who can help me out with something here. Ok...We have a retail shop and we want to see for each customer if he had bought at least once a month a specific product consecutively. To see the concept: If he had bought the product let say 2 two times in...

Hello, Is there a function or query that I can split a field into different columns? For example, I have First Name, Last Name, Address. But I want to split the address field into Address1, Address2, Address3, Address4 as the initial Address field has a lot of characters with commas e.g. 11...

Hi again, I need help on something else. I have a table with orders (100,000 records) and a table with customers (30,000 records). Consequently, a customer may have made multiple orders. Both tables have a unique id that link them together. My problem is that if I join them with a simple query...

Hi, I have a question about appending or adding simply records. Everyday, I get a database which is cummulative and I have a combined database with 3-4 tables from different sources but they have duplicates (same id, but different on other fields). I keep a specific structure. However, my...

Hello everyone! I am also new here! I noticed that this forum contains many information about Access and I believe that it will be very helpful! Thanks in advance and I hope you can help me with many question that I have. Cheers