Senin, 08 Desember 2025

Sabtu, 06 Desember 2025

Re: [MSAccessProfessionals] Conditional Number formating

The solution I have seen at a former employer was to have a second field to store the precision (# of decimal places). 

Duane
Sent from my mobile

On Dec 5, 2025, at 9:18 AM, Jane via groups.io <jcross=crossproducts.plus.com@groups.io> wrote:


Hi
I have a numeric field (double), which I need to save/ display exactly according to how the user entered it.  I don't want to change it to a text field as the system does use it for calculations. Also general formatting to 2dp for example will show all numbers the same. 
eg 

User Enters

Currently Displays

Required Display

10.50

10.5

10.50

11

11

11

10.0

10

10.0

 
Any suggestions?
Many thanks
Jane

Jumat, 05 Desember 2025

Re: [MSAccessProfessionals] Conditional Number formating

Hi Jane,

 

In some cases, it is OK to store a number as text, and then use it in numerical calculations. VBA or the Access Expression Service (if using a query) will do the type coercion for you.

Example:

Dim d As Double

Dim s As String

s = "10.50"

d = s + 1

Debug.Print d

 

This will print the number 11.5

 

You can also write the calculation as:
d = CDbl(s) + 1

This makes the type coercion explicit. That would be my preference.

 

If for some reason this is not good enough for you, then consider adding a text field to the table for the user-entered string, and turn the current numeric field into a Calculated field with the expression:
CDbl([yourTextField])

 

Best Regards,

 

-Tom van Stiphout.

Microsoft Access MVP

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Jane via groups.io
Sent: Friday, December 5, 2025 8:19 AM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] Conditional Number formating

 

Hi

I have a numeric field (double), which I need to save/ display exactly according to how the user entered it.  I don't want to change it to a text field as the system does use it for calculations. Also general formatting to 2dp for example will show all numbers the same. 

eg 

User Enters

Currently Displays

Required Display

10.50

10.5

10.50

11

11

11

10.0

10

10.0

 

Any suggestions?

Many thanks

Jane

[MSAccessProfessionals] Conditional Number formating

Hi
I have a numeric field (double), which I need to save/ display exactly according to how the user entered it.  I don't want to change it to a text field as the system does use it for calculations. Also general formatting to 2dp for example will show all numbers the same. 
eg 

User Enters

Currently Displays

Required Display

10.50

10.5

10.50

11

11

11

10.0

10

10.0

 
Any suggestions?
Many thanks
Jane
_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116717) | Reply to Group | Reply to Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Senin, 01 Desember 2025

Re: [MSAccessProfessionals] Different data in same column

Good morning Duane,

 

Yes, I was able to use a crosstab query as suggested.  Thanks for reaching out. 

 

Doyce Winberry

Manufacturing

Manager Systems

 

XPO

2001 Benton Street

Searcy, AR 72143 USA

O: +1 501-207-5973   M: +1 501-207-2269

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom via groups.io
Sent: Monday, December 1, 2025 6:40 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Different data in same column

 

Doyce, Is there any follow-up to your question? Did you get the assistance you needed? Duane From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Duane Hookom via groups.io <duanehookom=hotmail.com@groups.io>

ZjQcmQRYFpfptBannerStart

This Message Is From an Untrusted Sender

You have not previously corresponded with this sender.

ZjQcmQRYFpfptBannerEnd

Doyce,

Is there any follow-up to your question? Did you get the assistance you needed?

 

Duane


From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Duane Hookom via groups.io <duanehookom=hotmail.com@groups.io>
Sent: Monday, November 17, 2025 4:02 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Different data in same column

 

The "new" format is the most useful since it's normalized. You can create a crosstab query with the pay code as the column heading. The employee ID and I expect a date filed will be the Row Headings and Sum of hours as the value. 

 

Duane

 



On Nov 17, 2025, at 2:19PM, Doyce Winberry via groups.io <doyce.winberry=xpo.com@groups.io> wrote:



Friends,

 

We have a new timekeeping system and I'm used to importing hours from the old system into a database where it can be sliced, diced, grouped, and etc.  Unfortunately, now when I'm running a report to extract the hours, there are so many types of paycodes used that the report puts all the paycodes in same column and the hours associated with each paycode in another "shared" column instead of making a column for each paycode and putting the hours in the correct column.  See examples:

This is the report I get.

Employee ID

Paycode

Total Hours

30252579

PTO Scheduled Current Year

3.50

30252579

Regular

36.57

30244320

Overtime

0.20

30244320

Regular

40.00

30250342

Regular

40.00

30250342

Overtime

0.18

30079782

Overtime

0.38

30079782

Regular

40.00

30268802

Regular

40.00

30268802

Overtime

0.33

 

This is how I want the data with 1 line per employee ID:

Employee ID

Regular

OverTime

PTO

30252579

36.56667

3.5

30244320

40

0.2

30250342

40

0.183333333

30079782

40

0.383333333

30268802

40

0.333333333

 

Are there any easy ways to do this?  My thoughts are to query the top table with If statements to then use a totals query on the first query to put all the records into one row.    

 

 

 

Doyce Winberry

Manufacturing

Manager Systems

 

XPO

2001 Benton Street

Searcy, AR 72143 USA

O: +1 501-207-5973   M: +1 501-207-2269

 

Re: [MSAccessProfessionals] Different data in same column

Doyce,
Is there any follow-up to your question? Did you get the assistance you needed?

Duane

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Duane Hookom via groups.io <duanehookom=hotmail.com@groups.io>
Sent: Monday, November 17, 2025 4:02 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Different data in same column
 
The "new" format is the most useful since it's normalized. You can create a crosstab query with the pay code as the column heading. The employee ID and I expect a date filed will be the Row Headings and Sum of hours as the value. 

Duane


On Nov 17, 2025, at 2:19 PM, Doyce Winberry via groups.io <doyce.winberry=xpo.com@groups.io> wrote:



Friends,

 

We have a new timekeeping system and I'm used to importing hours from the old system into a database where it can be sliced, diced, grouped, and etc.  Unfortunately, now when I'm running a report to extract the hours, there are so many types of paycodes used that the report puts all the paycodes in same column and the hours associated with each paycode in another "shared" column instead of making a column for each paycode and putting the hours in the correct column.  See examples:

This is the report I get.

Employee ID

Paycode

Total Hours

30252579

PTO Scheduled Current Year

3.50

30252579

Regular

36.57

30244320

Overtime

0.20

30244320

Regular

40.00

30250342

Regular

40.00

30250342

Overtime

0.18

30079782

Overtime

0.38

30079782

Regular

40.00

30268802

Regular

40.00

30268802

Overtime

0.33

 

This is how I want the data with 1 line per employee ID:

Employee ID

Regular

OverTime

PTO

30252579

36.56667

3.5

30244320

40

0.2

30250342

40

0.183333333

30079782

40

0.383333333

30268802

40

0.333333333

 

Are there any easy ways to do this?  My thoughts are to query the top table with If statements to then use a totals query on the first query to put all the records into one row.    

 

 

 

Doyce Winberry

Manufacturing

Manager Systems

 

XPO

2001 Benton Street

Searcy, AR 72143 USA

O: +1 501-207-5973   M: +1 501-207-2269

 

Selasa, 18 November 2025

Step and Repeat Banners Continue to Redefine Event Visuals and Brand Engagement

FOR IMMEDIATE RELEASE

November 19, 2025

United States


The Step and Repeat banner, a distinctive visual element at gatherings worldwide, maintains its prominence as a fundamental tool for event organizers, businesses, and public figures seeking heightened visibility. Originating from the world of celebrity gatherings and photo calls, these branded backdrops have expanded their utility, becoming a staple across a diverse array of events, from professional trade shows to personal celebrations.

Step and Repeat banner features a repeating pattern of logos, sponsor names, or other brand elements, providing a consistent visual background for photography and media interviews. Its primary design purpose is to establish immediate brand visibility, allowing companies and individuals to maximize exposure through shared images and videos from their events. This repeated visual presence ensures that every photograph taken against the backdrop implicitly carries the event's identity or its sponsors' messages, creating numerous photo opportunities that extend brand promotion far beyond the physical location.

The versatility of the Step and Repeat banner extends to its construction. These backdrops are available in various materials and stand configurations to meet differing event needs and budgets. Vinyl banners, known for their durability and cost-effectiveness, are a frequent selection, particularly for outdoor use or settings where cleaning is straightforward. While vinyl surfaces can exhibit glare under flash photography, advances in printing technology have introduced matte finishes to reduce this effect. Conversely, fabric banners provide a premium appearance with a soft, non-glare finish, making them highly desirable for high-profile indoor events like Red Carpet Events and gala celebrations. Fabric options are often wrinkle-resistant, portraying a polished visual impact.

The physical support for these backdrops also presents choices. The banner stand is an integral component, offering portability and ease of assembly. Telescopic stands provide adjustable width and height, accommodating various space requirements and banner sizes. For a more seamless and taut presentation, pop-up banner stands, often utilizing tension fabric displays, create a smooth, wall-like effect, frequently referred to as a Media Wall or Logo Wall. These portable display systems simplify setup and breakdown, an advantage for event event planning teams.

Effective design remains central to a Step and Repeat banner's effectiveness. Custom design services specialize in arranging logos with appropriate spacing and repetition to ensure each brand mark is clear and unobstructed in photographs. High-quality printing is paramount, necessitating high-resolution graphics, typically vector files, to prevent pixelation when scaled for large format printing. Graphic design professionals guide clients in selecting suitable color modes and ensuring adherence to brand guidelines for a cohesive and professional presentation.

The application of Step and Repeat banners spans a wide spectrum of events. At Corporate Events and Trade Shows, they act as powerful tools for event marketing, attracting attendees and providing a consistent backdrop for interviews and company announcements. During Press Conferences, the repetition of logos reinforces sponsor recognition for media outlets. At private gatherings such as weddings or parties, personalized photo backdrops featuring monograms or themed graphics enhance the celebratory atmosphere and create memorable picture opportunities. Sponsorships are frequently highlighted on these banners, providing tangible value to contributing organizations through repeated exposure.

The continued evolution of digital marketing and social media platforms amplifies the value of Step and Repeat banners. Images captured against these backdrops are readily shared across social channels, generating organic reach and amplifying brand messages to broader audiences. This digital footprint extends the life of the event's visual branding, providing enduring returns on investment for advertising efforts.

Companies specializing in printing services offer a range of custom banners solutions, working with clients to determine the ideal materials, sizes, and stand types for their specific needs. From initial graphic design concepts to final large format printing and delivery, these providers help businesses and individuals translate their branding aspirations into a physical photo backdrop that makes a statement.

The Step and Repeat banner remains an indispensable asset for effective brand promotion and visual communication at any significant gathering. Its simplicity in concept belies its powerful capacity to elevate an event's profile and deliver sustained brand visibility in an increasingly visual world.


 Apex Display Solutions is a leading provider of high-quality event display products, specializing in custom Step and Repeat bannersMedia Walls, and trade show exhibits. With a focus on superior printing services and custom design, Apex Display Solutions helps clients achieve impactful brand visibility at Corporate EventsTrade Shows, and special occasions.  

--
You received this message because you are subscribed to the Google Groups "Broadcaster" group.
To unsubscribe from this group and stop receiving emails from it, send an email to broadcaster-news+unsubscribe@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/broadcaster-news/110036db-3533-4cbd-a370-f5b28be8942en%40googlegroups.com.