User Profile

Collapse

Profile Sidebar

Collapse
mattlightbourn
mattlightbourn
Last Activity: Oct 17 '07, 03:18 PM
Joined: Sep 18 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • mattlightbourn
    replied to Find out number of decimal places
    Found it!

    Code:
    SELECT Table1.accountID, string(8-len(FormatNumber([ref1],3))," ") & FormatNumber([ref1],3) AS Expr1
    See more | Go to post

    Leave a comment:


  • mattlightbourn
    started a topic Find out number of decimal places

    Find out number of decimal places

    Hi,

    I hope you're all well.

    I need to right justify some figures in a list box and the only way I seem to be able to do it is by using the number as text and doing something like this in a query.

    Code:
    SELECT Table1.accountID, string(8-len(ref1)," ") & [ref1] AS Expr1,etc, etc
    The above query for one of the columns, looks at how many characters there are and then adds spaces at the...
    See more | Go to post

  • mattlightbourn
    replied to Crosstab problem - driving me nuts
    I've been doing a bit more research and found that you should be able to do Concatenated results instead of a count or occurances.

    If concatenated results can be done, that is fine as there is only 1 occurance for each X meets Y relationship.

    Thanks again
    See more | Go to post

    Leave a comment:


  • mattlightbourn
    replied to Crosstab problem - driving me nuts
    Please, please, please - help me with this one - all other stuff falls into insignificance if I can't solve this issue!

    Hi all,

    I really need a crosstab query that allows me to view data rather than sum, count, avg, first, last. I just want it to show the actual data listed and can find no way of doing it.

    If a crosstab can't do it, is there a way of creating something from code to do it instead?
    ...
    See more | Go to post

    Leave a comment:


  • mattlightbourn
    replied to Crosstab problem - driving me nuts
    Sorry, replying to my own posts must be a bit weird, just adding a bit more detail - as I have tried a few things whilst I await a reply.

    SELECT Tbl_Garment_Typ es.GarmentName, Tbl_Sizes.Size, Tbl_Sizes.SizeB ase, Tbl_Size_Specif ications.BuyerR ef, Tbl_Size_Specif ications.Descri ption, Tbl_Size_Specif ications.Extend ed, Tbl_Size_Adjust ments.SizeSpecI D, Tbl_AdjustMeasu res.ChangeAmoun t
    FROM ((Tbl_Garment_T ypes INNER JOIN Tbl_Sizes...
    See more | Go to post

    Leave a comment:


  • mattlightbourn
    replied to Crosstab problem - driving me nuts
    On the above bit - I went into the original query and under [GarmentName] I put "Tops & Jackets" in the criteria field and saved the query.

    When I went to the CrossTab query, it just displayed the records I wanted and ensured that only the amount of columns I wanted appeared. Perfect.

    What do I put in the criteria for it to reference Forms!Frm_Main! GarmentTypesLis t as source of criteria?

    ...
    See more | Go to post

    Leave a comment:


  • mattlightbourn
    started a topic Crosstab problem - driving me nuts

    Crosstab problem - driving me nuts

    Hi all,

    I have a problem which has been driving me nuts. Crosstab queries!

    I have a database witch a few different tables to do with garment manufacturing.

    I have a table for a client account, garment type (Jacket, skirt, etc), client sizing spec and descriptives (measurement names i.e: Shoulder to cuff, inside leg, etc), available sizes (ie. 4,6,8,10,12,14, 16,18,20,S,M,L, SM,ML,One) and pattern adjustments...
    See more | Go to post
No activity results to display
Show More
Working...