tak786
Last Activity: Jun 5 '08, 03:25 PM
Joined: Dec 12 '07
Location:
-
Renaming Querys
Hello,
Im currently having a problem renaming queries. This is mainly because all the queries are linked together and changing one name will mean the rest of the queries wont work since it cant find that query anymore....
Is there a quicker way of renaming linked queries without losing the connection?
Kind Regards
Tak -
Hey,
The numbers are right aligned so they must be numeric, but I have used the count function which i assume makes it numeric since the fields im counting are in 'Text' format.
The numbers do total up and have been checked since im using a large amount of data. Not sure if problems will occur later on but for now it all seems fine.. :S
Thanks for the info it is much appreciated..Leave a comment:
-
its ok its sorted had to use the following and multiply by one first
Total: (1*[Cust])+(1*[CustMisc])
thanks anyway
kind regards
takLeave a comment:
-
hello,
Instead of adding the two fields its joining them for example
0 + 3 becomes 03
rather than just '3'
any ideas? thanks for your help..Leave a comment:
-
Sum problem!
Hello..
I have got 2 queries both of which have got count functions which count different customers, these are based against a month. I have created a relationship against them two tables and put the two count fields together matching the fields using the month.
This all works fine and the data is visible n example is shown below.
Month -----Cust-------Cust Misc
Jan----------10----------1 ... -
COUNT Problem
hello..
i have created query which has 1 "date field" which I need to count the instances of each month.
i.e
field 1: date field = count of "*01/2007"
field 2: date field = count of "*02/2007"
field 3: date field = count of "*03/2007"
etc....
The main problem being that I am creating extra fields from the one date field and...
No activity results to display
Leave a comment: