Search results

Got it sorted...

Try =DSum("Unitprice","DATA","[Account] IN ('Budget1', 'Budget2') AND [AccType] IN ( '013','064')")

Happy to help... :) Larry

Try this: =DSum("Unitprice","DATA","Account= 'Budget1' AND AccType = '013'")

you should set up a strWhere varible and build your string there. Dim strWhere as string strWhere = "[Dateofpurchase] <= # " & 01/01/1998 & "#" & " AND " strWhere = strWhere & "[Status] NOT IN ('Removed')" & " AND " strWhere = strWhere & "[Account] IN ( 'value1', 'value2', etc...) Then do...

I have a query that will pull the "Max Tissue Id" on the form I thinking it needs to be formatted like below..(ex: MaxTissueId = T11-0001) "T" & Format(Year(Now()),"YY") & "-" & Me.MaxTissueId + 1

Hey, I'm using Access 2007 and need to figure out a way to add 1 increment to a text field. I have an ID as an autonumber but for these purposes we have to enter a "Tissue Id" like this T11-1109...so the next one would be T11-1110 and so on... Is there a way I could auto format it like this...

I had the same problem with memo field before. What I realized is that I had a SELECT DISTICNT in a query...When that was there it only showed the 255 characters. After I took that off the memo field displayed as it should. You may want to check that out. Select distinct doesn't play nice...

Gotta it! Thanks for the "Kick"! Larry

okay...I see what your saying. if I take that table out of the SQL record source the ID shows up... Why does it do that?

I thought the record source was one table? Sorry but I'm not following. Could you elaborate or send me a copy of what your talking about?

Those other tables are look up tables or list tables...not really relavant to the Parent-Child issue. The fourth form is just an add item form...not connected to the parent - child issue One patient can have many reviews Donald had a "pre" QA review....then the coordinator fixes the issues...

See attached... It should open to the "frmMain"... I have all the PK to show in the text boxes Pick a name from the drop down Add a date or pick a Review type But the questions subform doesn't show the key to the Review date form Thx for looking! Larry

haha...I wish I were! There are many many of those guys here! you're welcome! Larry

Yes... Look for the properties menu for the form...not that familiar with 2010. you want to look for... probably somewhere in the "ribbon" Record selector Scroll bars Navigation buttons HTH Larry

Hopefully that will work for you! Welcome to the forum! Larry

if that's what you want to do and the are unrelated...sure. Open a New form in Design view - Main form The add the 3 forms as subforms to it...you wouldn't need to worry about linking the parent - child stuff because it's not there. So you'll basically have 4 forms - (the main will house...

Hey! I have 3 tables... CaseReviewed: QA_ID, CasefieldID (text) CaseReviewedDate: ReviewDateID, ReviewDate, QA_ID CaseReviewedDetail: CaseReviewedDetailsID, ReviewDateID, irrelavant fields... When I join the Main form (Case Reviewed) to subform(CaseReviewedDate) the master and child fields...

You didn't give them column names in the statement SELECT [ServerName], 04/25/11 AS [columnA], 04/26/11 as [columnB] FROM (SELECT ServerName, [Date], Hits FROM #ToPivot )AS Src PIVOT ( Count(Src.Hits) FOR Src.[Date] IN([4/25/2011], [4/26/2011]) )AS pvt Try that... if you got it...

Why not import the spreadsheet or Link the spreadsheet to Access? There you can create search forms, functions in ACCESS and not have to worry about EXCEL code? Just a thought...