Search results

I think what he wants is all the original data, ungrouped, with the count of it by the side: AAA | 3 AAA | 3 AAA | 3 BBB | 2 BBB | 2 CCC | 5 CCC | 5 CCC | 5 CCC | 5 CCC | 5

best bet is to: 1. make a query which does the totals, one column for "AAA" and one for "3" 2. make another query based on the total query, and add the table which the first query has. 3. Join the columns containing "AAA".

forgot to mention that all numbers that are outgoing in the UK start with a 0. Inland or international (+44 == 0044) So additionally I've added: IIf(Not IsNull([Phone1]) And Left([Phone1],1)<>"0",False,True) I hope this helps someone! SELECT IIf(Not IsNull([Phone1]),IsNumeric([Phone1])) AS...

Nevermind... I did this ol' beaut: IIf(IsNull([Phone1]),IsNumeric([Phone1])) IsNumeric can be used on a field of any data type (mine were text) and returns True or False. If everything in the field is a number, it will return true. This works perfectly for international numbers as well. Note...

he changed any reference to [CurDate] to just Date() TGIF ~Mike

Hello peeps. Before i continue: I know very well about excel's annoying removal of leading 0's. And i know it can be solved by making the column type, Text, not a number. :) What i'm working on is an excel spreadsheet importing module which validates data from clients and sends error reports...

I must admit I've never used self joins. One of my biggest problems with this project is to make it idiot proof. When i leave the company it needs to be able to be handed over to someone who may not understand SQL or Visual Basic like myself (or not, as it may seem...).

Cheers for the help guys. I knew this project was going too good to be true! The other option that i was considering is using the codes of the regions to define it's tier. For example, if MrCompany had 6 regions, and each region had 5 divisions, then i would have 30 different codes in the...

Afternoon. I'm working on a relational database for all of our clients and wish for it to be generic for the big clients and the small clients. My main table has fields "CompanyCode", "RegionCode" Some companies have 18 regions, others have 5 or less, some have none. For some of our clients...

Hello, I've read through http://www.access-programmers.co.uk/forums/showthread.php?t=139656]this thread which has given me a huge boost in the direction i need for a contact management system I am building. Now, the problem i'm having is that I'd love to be able to add my own columns to this...

no one? Sorry to bump.

Hi guys, I did search a lot for this so please excuse me if it has been mentioned before. (on searching "grammar" i came across quite a lot of flaming!) I'm looking for a way to check grammar in memo fields. There's a few things i've looked at and either come across issues with my inexperience...

Nevermind... i'm a complete idiot!! I was writing a html email and typed "<br>" then my heart sunk and my mind walked off saying "like fuck i wanna be associated with this guy". Sorry to be a pain!!

The difficlty is that i'm only having trouble with one text field, not the whole form (which has quite a few). What does outlook use to determine a carriage return?

Hello, I have some code which creates an email and inputs data from a form. One of the text boxes has carriage returns in it like below: "Hello World World Hello" When it gets put in the email it displays as: "Hello World World Hello" I really need to keep the vbCrLf. I've tried the below...

Hello, It's been a while since i posted here for help as my skills are getting really good! Anyway. I'm writing a system that imports spreadsheets from our clients into our database. I have made it so it can import as many spreadsheets as possible at any one time and it loops through them...

Jet sucks! My objective is to replace the telephone numbers in tbl_clients with the numbers in CheckFieldSheet if there's a different number for the same record in CheckFieldSheet. If i'm going about this the long way round, please let me know!!

I never understool nz, so i never used it. Am i right in saying that it'll convert a null value, to a figure of the user's choice, which can be represented as null? I did this: Number1: IIf([CheckFieldSheet].[Phone Number 1 *]=[tbl_clients].[Phone Number 1 *] Or [CheckFieldSheet].[Phone Number...

Here's my query. SELECT CheckFieldSheet.[Company Name] IIf([CheckFieldSheet].[Phone Number 1 *]=[tbl_clients].[Phone Number 1 *] Or [CheckFieldSheet].[Phone Number 1 *]=[tbl_clients].[Phone Number 2 *] Or [CheckFieldSheet].[Phone Number 1 *]=[tbl_clients].[Phone Number 3...

Hello, I have some complex reports which are giving me some real hassle. The process is this: In a form, they pull down a report name in a drop down box, then a print button appears. That button will append all needed records to a table called "tblVisual" using an append query, and edit every...