Report not working

[katmomo5]

Hi,
I am super new to access, and have done okay as far as smaller tables, queries, forms, and reports. I am now on the "big" report, that has 127 fields. The report was working fine until Saturday when it was 60 some fields shorter. I had to add more fields to distinguish values by work shift. So, I added these new numeric fields, which have the same properties as the others, long integer, default 0, etc. I add the fields to the query as well, then added to the form and report. Now, when I run the report, it does not pull up any data/record from after the addition of the new fields. When I run the report based on the dates before the additions were made, the report works populating the data that was entered that day. When I run the query, it also does not pull up the newer records, only the records from before the change. The only thing that works right after the change is the table. The table is populated with the newer data. I am about ready to start it allllllllll over again, but wanted to see if I could get help here. Thank you in advance.

[June7]

Did you run Compact & Repair?

Sometimes objects can become corrupted and have to be rebuilt. Try creating a new report and copy/paste all the controls from the old.

That's a lot of fields. Makes me think data structure is not normalized.

If you want to provide db for analysis, follow instructions at bottom of my post.

[katmomo5]

Hi June7,
I'm worried about the judgements that may come along with posting my db. I have a lot of trial and error objects that i'm scared to delete for fear of messing something else up. I'm about ready to buy Designer for Access. JK, don't have the cash to shell out for that. Anyway, I appreciate the help and hope that you are able to see what I am doing wrong. I did recreate the table, called it kcno. Created a quick form also called kcno. Ran a query, and it doesn't pull up.

[ItsMe]

The default value in your date field is Now(). This includes the time. Your query is requesting the DATE AND TIME. Maybe you can create an alias in your query that does not include the time from your date field. You could put your criteria there.

[katmomo5]

Thanks, will give that a try. Or is there a way to autopopulate with just the date?

[ItsMe]

I am not sure what that means, autopopulate. What is your goal? Maybe there is an easier way. You can format an alias to represent the date and not the time. I would be approaching this from a form, myself.

[katmomo5]

The form is supposed to be entered once daily. The goal is to be able to print that day's data once a day. I was trying to generate the report by entering the date of the report.

[ItsMe]

Is the date of the report always or most of the time the current date? You could place an unbound textbox with a date picker on a form along with a print report button. You could place the default value of the unbound textbox as Day(). VBA behind the button's click event could query the report, parsing the time from the date field.

[June7]

Not seeing db attached to post any more.

ItsMe, did you mean Date()?

kat, do you want the date saved in record? If not, can have textbox on report with expression in ControlSource to display the current date. Of course that means if you run report today but really wanted it dated yesterday, that won't work.

[katmomo5]

I do want the date saved in the record, in case we want to pull up data from a previous day.

[ItsMe]

Here is a solution. Open frmTest and click the button.

I ended up using the Between operator in a where criteria to open a form. Let me know if you need help changing that statement to open a report.

[ItsMe]

ItsMe, did you mean Date()?

I did. Maybe I can blame my wireless keyboard.

[Demerit]

ItsMe your SampleDate Db attachment is not opening. I don't know why. I get the msg "Unrecognised database format"

[June7]

It opens for me. It's a 2010 file that 2007 can't read. Sometimes happens. In this case, probably because there are calculated fields in the table - a field type introduced with 2010.

[Demerit]

OOps i see, am using Access 2007