Search results

I want to use a result from a calculated field in another calcalation but I don't know how to recall the first result. Can I give the first calculated field a name and then recall that name in the second calculation? Also, if I group my data, can I calculate a percentage in the group footer or...

No luck. I'm still getting an error. (English system ... used commas). Any other ideas?

I’m trying to sum the number of “Yes’s” in a Yes/No field on a report. 1) In the footer of the report I created an unbound text field 2) I then went to Properties, Control Source, and typed in the DCount function as follows: =DCount([FieldName],"-1") ... no luck ... I’m confused. Any help...

I’m trying to sum the number of “Yes’s” in a Yes/No field on a report. 1) In the footer of the report I created an unbound text field 2) I then went to Properties, Control Source, and typed in the DCount function as follows: =DCount([FieldName],”-1”) … no luck … I’m confused. Any help will be...

I have a report that is run from a query. The query selects records based on a parameter in a date field (between the two dates). How do I get the dates selected to appear in the title of the report without having to build a print dialog box? Thank you

I used the Chart wizard to add a chart to my report. I want to rename to X axis titles (title for each bar). I can change in design view but the field name in the query always appears in the preview view. I could create another query, creating new fields (linked to source) but this seems like...

How do I get a calendar to pop up for a date field? Instead of referring to a desk calendar one could click on the date in the calendar.

How do I get a field to default to the previous entry (same field previous record)?

Goal: I'm trying to create a small program to capture responses to interview questions. I first want to show a list of 100 or so questions which I will select 10. I then want those 10 questions to show on a form. I will then supply responses to the questions. My Approach: I built a table...

I'm new to Access, so I apologize if this question is simple. I have a list of 100 potential questions. I want the user to select ten of the 100 questions. I want those 10 questions to be imported into a particular form. I built a table then pared it down with a query but I don't know how to...