Search results

Thanks so many millions for all of your help. I think that it will benefit me to utilize the info for importing that you have given me b/c I will be needing to update this DB with the additional months that I will be receiving over a period of extended time for upcoming quarters and this should...

Exactly. I took this DB info from an xls. I created my tbls, qyrs and rpts from the xls. I did not use a form(to-date), but this may change as I receive additional information for the DB (which will also be an xls). Basically, I inherited a mess in the xls to begin with and I wanted to put it...

No, I am not using a calendar control. Actually, the original data was in a xls spreadsheet (which when printed made a wall mural of info), anyway I just converted to Access and organized the data so that the grouping of it was more orderly and organized. At some point, this data will be used to...

Now that really makes sense. I could have simplified the entire process of summing and grouping with that SQL. Cool running. I will plug it in tomorrow and let you know how she flew. Thanks. :p

I will give it a shot to see what happens. My original data, from an xls, included the total # of passengers who boarded or disembarked from a particular route as a number count. I first needed to have the numbers separate by ON and OFF; then I needed to have a sum of all passengers ON and OFF...

Actually when I looked at my qry I realized that I did the IIf:[loadtype]="on", [count],"") so that it would return my number count for the "ON" field. The actual SQL is as follows: SELECT [Qlink_Main tbl].Date, IIf([loadtype]="on",[count],"") AS BoardingOn, IIf([loadtype]="off",[count],"") AS...

SELECT [QlinkSum tbl].Date, Sum([QlinkSum tbl].BoardingOn) AS SumOfBoardingOn, Sum([QlinkSum tbl].BoardingOff) AS SumOfBoardingOff FROM [QlinkSum tbl] GROUP BY [QlinkSum tbl].Date; This is the SQL for the qry I created to sum a number field. The original qry consisted of two fields the listed...

Oh no doubt yourule with your Access wisdom. I mean for starters, you have enlightened me as to why I had the problem to begin with and that often times is an answer in and of itself. I think that until it is known how to overcome this issue, then I will just have to do a separate report for the...

Thanks for taking the time to respond. Actually, the problem was not in the query, but rather in the report. I created two subreports, one to be placed in the page footer and the other for the report footer. I wanted to group sums for figures by the group date (page footer) and by the month date...