Search results

Will do. Cheers Rich. Tommy B

Hi All, Been a while since I posted Things have been going well...but am now stuck Here is what I need to do... I have a table with circa 400k telephone numbers in it. These numbers have an analysis code next to them which is the first 6 digits of the number, thus enabling me to group...

Hi David, Many thanks for the reply mate. Help file cleared it up for me. What I wanted to (and now have) achieved was the ability for the user to select a number of CallID's to view on a report something like : 1,5,6,8,12 Buy adding >0 or is null into the criteria box it will return all...

Am trying to use above function to return a list of CallID numbers but when I enter the following in my select query it keeps putting the expr: in front of it? How do I add this as a selection criteria? InStr([CallID seperated by commas,Blank=All],[CallID]) Help me please!!!

Thanks mate Got it ;0 Have a great Xmas!

This works great! Thanks a million KK Time to go wow my boss Hope you and everyone else on this forum have a great Christmas and a prosperous New Year!!! Tommy B

Hi Guys, Been a while since I posted so I hope you are all well Here's what I am trying to achieve: I work in telcoms and need to design a report that shows me the minutes for a set of telephone numbers over the last nine weeks for trend analysis. So basically it looks something like this...

Excellent! This method works perfectly Thanks for the help Pat! Tom.

Hi Guys, Hope you can help me out What I am trying to do is identify duplicate records and delete them from my master table. I used the wizard to create a duplicates query, it returns the two duplicate records side by side (in actual jfact about 45,000 records side by side!!!)Now what I...

Nice one...thank-you for taking time out to help me. This forum is without doubt the best place to learn new skills

This works great...thanks! I have one question though, I have based my combo box on a query. When I use the wizard to create it I want to bring in quite a few fields. Initially the combo box showed all the fields when I just wanted the user to see client name. I got around this by minimising the...

Hi Guys, I am just moving into the realm of vba and could do with some help! What I am trying to achieve is this: I have a form called onenumberformtest, this form displays a table called "Rates Table". The field [Client Name] is a combo box and feeds from a table called "client standard...

If you have the field that shows datedif, why not create a new field called say difference with an iif statement. This might work: Difference: IIF([DateDif]<=24,"Y","N") then in the criteria element put Y. Hope this helps, Tom.

Hi Susan, Got a couple of thoughts on this..you could put the following in your select query : Like [Enter Company Name]* this will tag a wild card to the variable if they are shortening the name. Or for a more robust solution: Create a form with a combo box that feeds from a table, lets call...

Hi Guys! Hope someone can give me a clue on this one I want to design an update query that references a set list for its update options. What I have is a list of telephone numbers, I am using Between [] and [] to grab the range to update, but what I need is for the next few fields to have...

Thanks for this Pat...I will play around with the idea and see what happens As always I greatly appreciate the help! Tom.

Yep. Its the code for autogenerating a range of numbers that I really need. Although the information you just gave is very useful too...thanks :-) Would be great if you could help me out!!! Tom.

Hi Guys! Its a while since I had a post...life has been quite ;-) But that never lasts long at work does it! So here is what I am trying to do: I work in telcoms and need an automated system for provisioning new numbers. What I need is a two table system, the first table uses an autonumber ID...

Hello All! I really hope someone can point me in the right direction here!!! Basically I have a report that has various summed footers and then a report footer that gives grand total. When I exported this into Excel it appears as a subtotalled spreadsheet with the footer cells as sum...

Hi Guys, Hope you are all well! Here's a funny glitch I have noticed with Access 2k. I have just convereted my '97 database to 2k and when I export an access report into Excel 5-7 format the calculated cells are lost!? The subtotalled breakdown appears as normal...but as I said...no totals...