Recent content by kflick

use columns as long as you don't miss any days of the week you could set up 6 cols on your report and go across then down that should give you the appearance you want

I have three subreports each of them will format the data in cols as expected when previewed individually when they are inserted into a main report they print in cols as expected .... until I add page breaks when i do that only the last subreport will print in col I can change the order of...

hmm... I have appologzed for what I thought was and my rudeness. I presented the challenge for fun (If its a big deal - forget it). I have a solution that works for me. I am a bad person. And probably stupid too. RV I'm sure Doc and Pat appreciate your protection. But if you don't have...

oh oh are you suggesting that I modify the sql statement of the basic select query that I create? I don't remember seeing any format statements in the sql statement after building it and formating the feilds in the statement builder GUI thingy, but then I never looked. I never thought of...

I have a challenge for you send me a text file with a 9 digit number; -no decimal -decimal places -with leading zeros -exported from a numeric field. ( It has to do be numeric because it is a calculated value.) (price - cost) units = unit price all * 100 and...

You misunderstood me I was appologizing for ME being pissy. Doc was just trying to help. I was using the export query method as described but it failed to work for me on the last feild becauase it was numeric i think. The export insisted on adding a decmal and 2 zeros to my last field. I...

First off Don't reply to people who are trying to help with a pissy attitude! so again i appologise for being an ass:( I ended up using code to do the formatting required. Open "testfile.txt" For Output As #1 Set rst = db.OpenRecordset(sql) rst.MoveLast cnt = rst.RecordCount...

sorry if I sound like an ass on my last reply . This is just bugging me. this rtf file shows the proper format ... ooops no rtf allowed sorry

I generally use the help section before I ask for help. If the answer were there I wouldn't have wasted my time or yours. I did look in the help section again and although my result screen now demonstrates the proper format the export dose not. I don't want to use code to accomplish this...

I have a requirement to export a 9 digit number to a text file with leading zeros and no decimals also a upc code as follows X XXXXX XXXXX X and scc code x XX XXXXX XXXXX i got the exporting working fine with the exception of the formatting i tried an input mask but maybe i don't know what...