Search results

Any idea's for this one? I have a part table summary with various quantities 1-1000 and want to create a new table where part number repeats with quantity of 1 corresponding back to the sum. If part 123456=20 then this would repeat 20 x and each record Qty=1 Start with summary...

Hi All - I've created a simple listbox on a report in MS Access 2010 so that there are two options A or B. Default is option A and I am able to change that to option B when in Report View, but if I switch to Print Preview, the report is refreshed and value defaults back to A. I have done...

Well - It almost works, but the dash is not recognized. I would like it to be a literal interpretation. Current result appears to ignore the dash "-" altogether? Between "AA-*" And "ZZ-*" Between "AA[-]*" And "ZZ[-]*" I thought that would do the trick, but no such luck.:confused: I just need...

I have two address fields that I want to tack together due to space contraints. =([add1] & " " & [add2]) Seems to work in a query but not report? I've tried a few other ways but no luck. Any feedback would be appriciated. :banghead: Thx

Hi - Trying to split this up through Access 2010 query. Example: "COMPANY FF - DAVE GROHL" String lenth is variable and delimiter is "-". I have this working for one side. CONTACT: Trim(IIf([SCOMPANY] Like "*-*",Right([scompany],Len([scompany])-InStr(1,[SCOMPANY],"-")),".")) Can not get...

Hi All - I was wondering if anyonce else has encountered this issue. I have a Basic select query returning results that change when I turn on totals, so all columns have a Group By. The actual data is very different which is puzzling. Quanties change, but there is no SUM applied, dates...

I'm new here 04/18/2012.:D I have been using MS Access since 1998. There a many people who like to look down on Access due to the fact it is considered a personal soultion vs. an enterprise solution. I think they are too quick to dismiss a very powerful tool! I learned from an old timer who...

Hi - I was wondering if there is a funtion in Access similar to NTILE or if I need to create a custome function for this. Anyway I'm out of idea's. Basically I would like to calulate top percent of values contained in a cost column of ~15,000 records. The top 75% of values = A, etc...