Hi. I created a query using a TRANSFORM statement that shows me the data I want to use. Now I am trying to use the results of this query in an Access report but the data in the PIVOT field "Quad" is not always the same. Since the values in the field QUAD become the field names for the report...

I have a report that groups on 'PilotName' and displays data correctly. I would like to add a Function to the Group that uses 'PilotName ' as a parameter from each group. My function works but only uses the first PilotName in each group. How can I pass the PilotName for each group? FEReport...

Is there any particular difference in using "SELECT" rather than "VALUES"? Also, what is the difference in having CHR(34) as opposed to using CHR$(34)? (This is a followup on a previous question.)

Is there any particular difference in using "SELECT" rather than "VALUES"? Also, what is the difference in having CHR(34) as opposed to using CHR$(34)? (This is a followup on a previous question.)

Revised - I found that the setting of a Label may be a possiblity, however what is the propr syntax in pass a value to the caption when you need to parse the field name together with the variable. ie. Forms![frmEquipAPCountDetail_sub]![Inv] + x.caption I have a continuous form that I need to set the...

Revised - I found that the setting of a Label may be a possiblity, however what is the propr syntax in pass a value to the caption when you need to parse the field name together with the variable. ie. Forms![frmEquipAPCountDetail_sub]![Inv] + x.caption I have a continuous form that I need to set the...

Revised - I found that the setting of a Label may be a possiblity, however what is the propr syntax in pass a value to the caption when you need to parse the field name together with the variable. ie. Forms![frmEquipAPCountDetail_sub]![Inv] + x.caption I have a continuous form that I need to set the...

How do I hide the total columns in a Pivot table? Karen

Background: This has to be accomplished using VBA code since only MS Access runtime is available on the machines running this appplication. A full version of Access is not available. I have a typical, at least to me, application distributed to many clients. There is a front end MDE installed locally...

Hi experts, I attach the following code. I am trying to get a Save dialog box up that will allow me to select a drive letter (using the browse facility) and put the drive path into my field called "BrowseLocation". For example, the pop up should open and allow the user to select drive G:\ and...