Quick Access Question

I'm trying to design a report off a table that I created.

One of the fields that I need (called "fledge date") is missing when I invoke the "create report" wizard. It's the one I need, and it seems to be the only field missing. Any idea why this one value would be missing? I can see it just fine in the table, but it's not an option when generating a report. However, I can see it fine in datasheet view and design view.


Thanks.

Are you sure it's not already a selected field and you don't have a scrollbar in the wizard do you?

What version of Access?

If nothing is working for you I might suggest creating a query with exactly the fields you need for this report and try to build the report off the query instead of the table.

I'm not familiar with this particular issue.

i scrolled through all the options in the wizard and it's the one field missing.


2007



I'll try the query, thanks. I have a feeling it won't be selectable there either, but we will see.

Write the query freehand if you have to :-)

SELECT Field1, Field2, Field3 FROM MyTable ORDER BY SomeField;

thanks again.

the field doesn't show up in the query wizard either. it's just this one field. what would prevent it from showing up as a usable field? anyone?

Did you try adding it to your query with SQL view by hand? Just get the other fields in there then switch to SQL view and type it in ... if it doesn't work there's something wrong. You might want to rebuild the database I can explain that if need be. Access DBs are notorious for going corrupt, but they usually just crash when you open them when that happens.

Meanwhile can you post a screen shot of the table in design view? It might be telling.

Sure, it's attached. The field not showing is "fledge date"...I displayed the properties for that field, too.

Um ... that's not a field in your table you're calculating it on your form. Go to the table not form design and I bet it isn't there, right?

So simply put the calculation in your query

SELECT Field1, Field2, Field3, DateAdd("d",27,[Actual Hatch Date]) As [Fledge Date] FROM MyTable;

Will try that, thanks.

Any idea, though, why this would happen for this 1 item?

Because it is not actually a field in your table. Go look at the table design and you won't see it I guarantee. What you showed in your screen shot was a text box on a form not a field on a table ...

If the fledge date is always 27 days after hatch, you don't need a fledge date at all as it can always be calculated off the hatch date ... or am I wrong, again?

You're absolutely right and that's what is happening so far as I've observed so he merely needs to base his report off a query and put the calculation in the query.

yeah, makes sense now. the funny thing is i built this database. let this be a lesson to the kids that being self-taught = gaps in knowledge.

I dunno about self taught, almost everything I work with including Access and VBA I taught myself. I just had a lot more time to learn from my mistakes prolly ;-)

I don't use 2007 we're still on 2003 and people are pretty opposed to installing Office 2007 everyone hates it. I see my "Design View" might be misleading. I was looking for this, but you showed me the right thing anyway: