473,508 Members | 2,110 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Help creating a custom formula field to use in a Cross-Tab Report.

Ok, I will try to explain first the escenario. I am trying to concatenate 6
fields so they can be in the same row using a cross-tab Report. The thing
is that two of these six fields are numeric fields. so they have to be
right-aligned, but the rest are text so the are left-aligned.

Rightnow my formula code aligns all the fields perfect but all of them are
aligned to the left. I would like some recomendations on how could I align
the two numeric fields to the right.
Thanks for any suggestions.


Ucase(Trim({tblUsuarios.ShortName}))& Space(30 -(Length
(Ucase(Trim({tblUsuarios.ShortName}))))) &
(Trim(Cstr({tblUsuarios.cantidadlinea}))) & Space(25
-((Length(Trim(CStr({tblUsuarios.cantidadlinea})))) )) & " " &
Trim(CStr({tblUsuarios.disponible}))& Space(25
-((Length(Trim(CStr({tblUsuarios.disponible})))))) & (Trim(
{tblUsuarios.Org})& Trim({tblUsuarios.Customer})& Trim({tblUsuarios.Nota}))
Nov 21 '05 #1
0 786

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
14966
by: Indraneel Sheorey | last post by:
Hello, I want to set up a query in SQL Server that is "grouped by" a variable PRICE. Since PRICE takes on continuous decimal values, I want to create deciles based on this variable and then...
1
2310
by: James M via SQLMonster.com | last post by:
Hi, I'm trying to count field login totals for users which updates another field in another table. Which is the most efficient method? I don't want to use a standard query as it will take too...
11
1894
by: milkyway | last post by:
Hello, I have an HTML page that I am trying to import 2 .js file (I created) into. These files are: row_functions.js and data_check_functions.js. Whenever I bring the contents of the files into...
3
261
by: Del | last post by:
Hello, I am creating a database that will be used to keep track part numbers being assigned to new parts. The main table (tblServPartNbrLog) has a part number field. This is a text field and is...
1
1130
by: christian | last post by:
Hi all, I'm creating a TimeSheet Database and I need to calculate two different set of times in one field (workedhours).Does anybody knows a formula that will allow me to add(Hours and...
3
3975
by: Nigel C | last post by:
My problem is best explained by way of tables and examples... I am using Access 2000 (in case this is relevant) and I have a table with the following fields... Field names ------------ Code ...
19
6694
by: trint | last post by:
Ok, I start my thread job: Thread t = new Thread(new ThreadStart(invoicePrintingLongRunningCodeThread)); t.IsBackground = true; t.Start(); There are lots of calls to controls and many...
1
1222
by: Ben Pursley | last post by:
I would like to add a column to a datagrid and populate that new cell with a custom formula like: Minutes Custom Field --------- ------------- 240 4:00...
3
1987
by: Melon via AccessMonster.com | last post by:
If anyone could take a look at this, I could do with the help. Im running into 2 problems with my db. 1) I have a members section in my db. If a member is selected as senior, all fields apply...
4
1275
by: Tony | last post by:
I'm trying to create a formula in dot net to achieve the following: Input: Output: 1 1 2 1 3 1 4 4 5 4...
0
7225
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7385
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
7498
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
5053
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
3195
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3182
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1558
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
766
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
418
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.