Recent content by nick941741

Firstly I'm not sure if this is in the right place, so appologies if not. I have a database that is a montly mobile phone bill, its quite a large one so that's why I use access to then run some queries and supply the user with a breakdown of their bill. 1 thing I've got an issue with is that...

Thanks Dave, I'm going to have a bash at this at the weekend, so no doubt there will be a few more posts within the forums as I get stuck. Much appreciated. Nick

Nice one, thanks Dave. The only reason I was changing the names of the fields was because they come in as Date, Time and someone mentioned about them being reserved names within access. Nick

Hi Dave, yes of course the file is a csv. I'm still wondering how to go about making my changes though, whether to do it via a VB script once the data is in. This is basically the process I need to run. Import raw data Change field names Change Date - Change from Date> date_of_call Change...

Sorry guys, thanks for the replies, I got side tracked with another project. I will no doubt be asking for more help real soon. Nick

Hi, I've got a large spreadsheet that gets delivered every month with a customers mobile phone bill contained within it, there are several reports that need to be run from this and also several problems that need to addressed before the data can be exported/imported to access. The headings...

Thanks Brian, I managed to sort it out just before I got your reply. Very much appreciated

Ok, so I'm not 100% sure where to enter this. The fields I have are usage date and usage time. Nick

Sorry, of course, current formula is Between #19:00:00# And #23:59:59# Or Between #00:01:00# And #07:00:00# There is probably a much better way of writing that. Nick

OK thanks Brian, not sure if I made it clear. I need all the calls that are made on a Sunday as this is considered out of hours, whereas Monday - Saturday only calls made between 19:00 - 07:00 are out of hours. I have a formula that works for out of hours, but its just getting the Sunday bit...

Hi, I have an access DB that is a large phone bill for multiple mobile accounts. I need to create a query that will return calls mode out of hours, out of hours being anything after 7pm and between 7am Monday to Saturday and anything on a Sunday. The fields are simply Time and Date Any help...

Sorry for the delayed reply..... So, would using a drop down list stop the recalculating then? There is no real need for the user to be able to scroll through the list as there will be too many clients for them to just scroll and select. I have added a quick search on surname field to the...

Thanks for the replies guys, it makes sense now. It was basically so I can make the membership expire on that date, or not expire if they are the other type of member. I will just run this as a report instead when its required and calcualte it then. Looks like I need to go back and review...

Thanks for the reply. Is there a better way of doing this then? It tends to slow things down quite a bit and doesn't look great either. Nick

Hey, thanks for that. I am interested in hearing why you wouldn't want to store this anywhere though, what would you do instead? Thanks Nick