Search results

Thanks very much-I'll try this out!

Hi Everyone, I think this will be an easy question...... I have a database for a membership programme and fields include join date and cancelled date. I want to count how many members have joined by month and members cancelled by month. I've done a simple Group by query, however the date...

Hi everyone, I've got what I thought would be a simple query but I can't get it to work. I've got two fields: Membership ID and Number of months. I'm using a group by to count the number of membership Id's. This works fine until I add a third column to the query which is 'Age group'. Now...

Thanks Harry, Very much appreciate the response-it's crucial information that doesn't seem to appear in the help file! Now the next thing is that the table is from a linked excel file-can you change the dates to long year in Excel or Access? The data is from an oracle database extract so I...

Hi Iiselle, Thanks for the reply-not sure what you mean when you say 'if the birth date is greater than the present date' all the dates are in the past, the example I'm using is for somebody born in 1928. Could you explain a bit more? Much appreciated! StephenD

Hi, Hope somebody can help.... I'm using the datediff function to calculate the age of somebody based on a date of birth field:- Datediff("yyyy",[dob],now()) It seems to work apart from older ages-for example I have a date of birth of 17/9/28 and it's returning -27 Can anyone help me/tell me...

That's great, thanks Pat I will go and try this out!

Does anybody know what is the best way to group data in a query?? I have a big chuck of data with a date of birth field-I want to add an age group field based on the date of birth e.g 0-17 years, 18-24 years and so on. Can you do it using IIf or is there another way??? Thanks!

Thanks Harry! Does it export the data to a completly new sheet in the specified workbook or can you specify an existing sheet? Also the format will remain the same with the same fields, however the number of rows will increase-would the code be written in Excel? How would I do this?? Thanks again

Can you program Access to export a query into excel, then have excel create a graph on the newly exported data? I'm a newbie to VBA and was wondering how complicated this would be? I've read something about arrays, and also I'm aware of the transfer spreadsheet action but I'd like to go a step...

Thanks Pat, I now understand! Sorry for being a bit slow! Thanks JesseB, I 'll give it a try!

Thanks Bob, How do I link the data? Is it complicated? Could the graphs also be linked?

Thanks Pat, I did have a quick look, although I think my situation is a bit different from the example in the article-I basically have a set of 1 million records, 40% of these will never change and will not be in the new files I will be recieving. That leaves around 600,000 records which may...

Thanks Pat, Is it fairly easy to setup a procedure that will run a number of queries at the hit of a button? I have a hefty number of records in my database and each query I run is taking 1-2 hours, it wolud be nice to just press a button at the end of the day then come in the office in the...

Ok here's my problem (challenge!).... I have one table with approx. 1 million records with the following fields: Membership ID, Joining Date, Cancellation Date Each month I will be appending new data to the table which will have the same fields. I don't want to have any duplicate membership...

Hi, The database is based on 1 million records which I'm importing from an Oracle database extract. I don't think excel could handle this-I suppose I could summarise the data in access in some way then export query results to excel? I was hoping to cut down on the data exchanges.

Does anyone agree that the charting function in Access (97) reports is the pits? I have a chart with number of days on the X axis and number of members on the Y axis. The default scale on the X axis is stupid-I went into the chart to change the scale but it doesn't see it as a number-it...

Hi, I'm currently setting up a database that every month will import a txt file of around 1 million records-I think I'll be using the transfer text method. However, this appends records to existing tables-I want to first empty or clear the existing table to overwrite with the current data. Can...