Const SQL = "SELECT petrol,dateofS,stid,totalS FROM details where stid="
Dim strSQL As String
strSQL = Replace(SQL, "petrol", Forms![searchfrm]![activitycmb])
strSQL = strSQL & " " & Forms![searchfrm]![stidcmb].Value & ""
i will select values for activitycmb and stidcmb through combo box...
then i will have record which has petrol.dateofs,stid,totalS........
now how can i display into the report
Marshall Barton said:
Normally, a report is design to work with a specific set of
fields and the query is required to supply that set of
fields.
If you do not know what fields will be available to the
report, then you are into an extremely advanced programming
problem, that, from the tone of your question, I don't think
you're ready for.
Quite probably you do not need to get involved with the
general problem, so I suggest that you explain speciifically
what you are trying to do. Then we'll see if there is a
specific solution that may avoid all the generalities that
you are asking so far.
ismail wrote:
thanks for explaining.......the things...u see normally i assign record
source and
then i get fields..i drag into reprt..i adjust...but...now...i have sql
string in my report
open event...then how can i use different fields in my report
ismail wrote:
i used to make reports by wizard...but now....???
i would like to make report...and the query is in coding..ie VBA query..
how to connect this query to my report and get the fields...into the reprt
if u give me sample code ...better for me....
:
A query is an SQL Statement, regardless of where/how you use
it. Even the query design grid is just a user inteface that
makes it convenient to specify the elements of a query, but
behind the scenes, Access uses the grid info to construct an
SQL statement. What all that is leading up to is that you
have to embed your "VBA query" as an SQL statement in the
context of a VBA procedure. Example:
Dim strSQL As String
strSQL = "SELECT f1, f2, ... FROM table WHERE ..."
Me.RecordSource = strSQL
Note that a report's RecordSource property can only be set
in the report's Open event procedure.
