Search results

My report has a page for each day of the week. Example: 12/01/02- page 1 12/02/02 - page 2 and so on for an entire year. My question is how do I open the report so that it will open on the current day, but allows me to go forward or backward to view other days if necessary? In my query...

I want to thank everyone for helping me with this project...and a special thanks to Rich and Pat. I now have this project completed and behind me and waiting for the next one. But, I wanted to write this for others that may be as much of a novice in Access as I am. You kept saying to set the...

Rich, I opened the report you sent back and it works like a charm!! Exactly what I needed....Thank you so very much Now, why would it not want to sum in the footer with nulls?

Pat, Thank you for answering. I admit my knowledge of Access is limited. And as far as I know, I have "fixed" the column heading for paycode to show as follows in criteria line In("reg", "ot") And like I said before, it does this correctly WHEN there is ot. The problem occurs when there...

Rich, I put Nz([ot],0) in the criteria for column heading Paycode I wasnt sure what to put in crosstab line, but I tried group by and where. Neither worked. It keeps saying doesnt recognize ot as field name or expression. Maybe I am going about this wrong. Do I need to fix this in the...

My report does have the column for OT. And the report will not open if there is no OT. It says "Microsoft Jet Engine does not recognize [ot] as a valid field name or expression." And I understand that it cant pull ot into the report if there is no ot column heading. That is the dilemma. How...

Techino I have already tried that and it doesnt make an OT column heading if there is no OT. Any suggestions?

I cant seem to grt it to attach. Could I try to email it to you?

I have asked this question a couple of times but maybe I was too wandering when I posed this problem. And I really need help on this!!! A crosstab query queries only reg and ot as column headings. My report pulls from this query and is set up to show reg hours and OT hours in separate...

Thanks for your answer. I was wanting to take classes at a community college and they offer basic programming...Maybe, I should contact them to be sure it is Visual Basic Thanks again.

Can someone enlighten me on the difference between Basic Programming and Visual Basic programming? or is there a differnce? Thanks

Thanks, Travis I have already tried that. In fact, this is what I have in the criteria section of column heading PAYCODE. In("Reg", "OT") And the query works fine, If there is no OT for that week the query simply shows only reg hours. It is when I try to open the report that I encounter the...

I have a report that pulls from a crosstab query. The report shows Reg and OT hours for employees in a certain time frame. The query works right, but when I try to open the report and there is not OT hours, the report says Microsoft does not recognize " as a valid fieldname or expression...

Thank you for answering..but since my crosstab query field name is actually paycode, that is the field that i made a column heading, and paycode queries to many column headings such as, Reg, OT, Sick, Vacation, so I dont actually name the heading myself. I still dont get how to make sure the...

I have a crosstab query that pulls out Reg and OT hours for depts. The problem is two fold: first - One of the messages I get when trying to run the report is this The Microsoft Jet engine does not recognize " as a valid field name or expression. I am not quite sure what this is telling me...

I did what you suggested and it worked but I cannot surf backward to see earlier dates only dates now and in the future. The navigation bar is grayed out for moving backward. And you know, I didnt make myself clear in the beginning. I want the report to open to current date but be able to...

Thanks for the answer but, whenever I put in this code, it highlights rptCalendar = "Calendar" (Actually it only hightlights the words rptCalendar) and gives me this message: Compile error Invalid use of property (and when I go to help it talks about get and let) Can you suggest what I...

I have a very quick question. My report pulls dates from a table that has every day of the year in long format for the next few years . Each page in the report is by date such as: page 1 heading is 9/17/2002 and so forth in succession. All I want to do is to open the report every day at the...

Okay, thanks for replying.. Noreene

Thanks, Rich The gray area is still there just around the left side and top