Search results

Urgent help needed Hi Everyone!, Can anyone help with this post? It's now getting pretty urgent! Any help would be greatly appreciated! Sasha.

Thanks for the quick rely!, I will give this a try. Regarding categories-at the moment I just want to have seperate lists of unique customers for each category, so I guess I can just add the category field into the query. What I ultimately want to do though is get a breakdown of customers and...

Hi Everyone!, I have a table with the follwing; ShopID, CustomerID, Month, Item_ref, Product Category There are about one thousand shops. The CustomerID field is only unique per shop. I.e. all transactions for customer ID '002' in shop 1 will be for the same customer, but customer ID '002'...

Hi Jon K, you posted this reply to my question a few weeks ago. Since then I have been on vacation and off work, so I've only statted to look at this again now! thanks again for your reply. A colleague of mine who is a statistician assures me that for 6 product types there would be 64...

A bit dissappointing. I thought you would be able to view all the tables, fields etc. available in the selected database and also have a results pane or export to file etc. as you can in SQL query analyzer. :(

Hi Everyone, I want to perform queries that count the number of customers using combinations of different products. The data is organised like so: CustomerID ProductType No of Items 1 A 5 1 B...

Hi, I can't get this to work. It comes up with an error message: Application Error: The application failed to intialize properly. Click OK to terminate. thanks! Sasha.

Thank you Mr Doc Man :) , You have provided me with some food for thought! I believe all the steps can probably be automated, Your paraphrase sounds accurate! the overview of the steps are that we are calculating montly year on year sales for a large number of shops and we only want to include...

Thank you Mr Doc Man :) , You have provided me with some food for thought! I believe all the steps can probably be automated, Your paraphrase sounds accurate! the overview of the steps are that we are calculating montly year on year sales for a large number of shops and we only want to include...

I am hoping someone can give me guidance on a fairly major project I am working on. I am responsible for producing lots of figures, charts etc. each month and the current process takes a very long time! I have been charged with improving this process, which currently includes the following:-...

Hi Everyone, I want to be able to transpose and transfer data from a CSV file into Access. The format of the data is as follows:- Jan-04, Feb-04, Mar-04, Apr-04 etc. Shop1 xxx xxx xxx xxx Shop2 x xx xxx xx Shop3 xx x...

Hi Ken, No they are not in native access date/time fields-the data comes from an extract off a SQL server database.

Hi, I want to calculate the number of days between 2 dates using the datediff function, however the dates are in a strange format: YYYYMMDD Would I first have to format the dates? If so, how would I do that? Many thanks, Sasha!

Hi everyone, I have a table which has the following 3 fields:- Customer_ID Shop_ID Month I need a count by month for each shop for the number of unique customers. There is a complication in that the customer ID field is not unique from shop to shop. E.g. there could be a customer ID number...

Hi there, It's not the screen size but the screen resolution setting (e.g. 800x600) that you need to look at. If you do a search on this forum on screen resolution you should come up with some examples of code that does this.

Thanks Pat, I'll give it a try!

Hi Everyone, I have a database where the file size seems to be getting bigger and bigger. It doesn't contain any pictures or images, just a few forms and quite a few tables and queries. The database was 160mb, I've compacted it which has reduced it a bit, but it's still 130mb. I'm not sure...

Hi there, this is the record source:- SELECT [Monthly Issues Data].Supplier, [Monthly Issues Data].M8, [Monthly Issues Data].M9, [Monthly Issues Data].M10, [Monthly Issues Data].M11, [Monthly Issues Data].M12 FROM [Monthly Issues Data]; thanks, Sasha_D

Anyone got any ideas???? I am getting very desperate now!

Thanks for the reply, When you say go to the graph property where do you mean exactly? I've clicked on the graph, then properties, then 'rowsource'? If I click into rowsource it gives me the query that it's based on. This shows the fields M1, M2, M3, M4, M5 etc. It doesn't show the month...