Search results

I would like to create a report or form that shows a summary on top and the detail information below with the ability to collapse and hide detail information.

I'm not really good with vba can you right in detail. What you referred me to is not in detail. Maybe i need to explain a little more. I have a form it's call frmRnCompletion. It has id field name RNcompletionID (number filed). I have a form called qryCSGAuditWorksheet it also has a...

I'm confused. what do I write to linked the form "rnid" to the report id "rnid"?

I want to be able to open report with button that only shows the report to the current form record.

I'm not having a problem when opening in word only when I attempt to run this code in Access.

Getting an error when attempting to use data from access in word document. The error says "Word was unable to read this document. It may be corrupt. Try one or more of the following: Open and repair the file. Open the file with the Text Recovery converter." The document doesn't have an issue...

It works I just left out another formula. Thanks!!!!!!

Ok this is what I have entered into the query Switch([BilledAmount]<[Final EOB Amount]="partial",[BilledAmount]=[Final EOB Amount]="approved",[Final EOB Amount]=0="denied"). However, I am getting a error message. What am I doing wrong?

Yes, I did. Unless I'm missing something, which I could very well be, I don't see anything that applies to what I need.

Please explain further. with choose I have to decided the postion i want to be return, right? What I need to do is to be able to return 3 different values. If a>b="Hoop" a=b="stop" a<b="Help". I can't use a iff statement because it only returns 2 values. I need 3 or more values returned.

I need to be able to create a multiple function that will return 3 different outcomes for example: if column A =1 than return value "Help" or if column A=2 return value "Stop" or if Column A=3 return value "More". Is this still a iff statement or do I use another function? If so, how do I...

I guess there could be multiple "no" but only one "yes". But if you have a better way of doing this please feel free to let me know your thoughts.

I have a child table that has childtableID, ParenttableID and checkbox(yes/no). There are muliple records that have the same ParenttableID. I want to validate the checkbox to only allows one checked(yes) box per ParenttableID. Can someone help me:confused:

I need to be able to calculate how many saturdays and sundays in a date range to substract from the total days (for example: between 1/1/2011 and 3/11/2011 there is 12 sundays and 11 saturdays). I can do this in a form but I want to be able to do this in a query.

Is there some way I can determine what day of the week a date falls on within a query? Also, is there a way I can count how many wednsdays (for example) there is in a date range with in a query or is this a expression that only can be done with VBA, a form or a report? :eek:

I tried iif(isnull([date closed]),datediff("d",date(),[date opened]),datediff("d",[date closed],[date opened]) This is for Acess 2003

I need to write a statement that does the following: If closed date is empty than subtract date opened from today’s date if not subtract closed date from opened date.