Search results

In design view of the report, go to the Property Box->Format Tab and look for Keep Together. It's either that or you have Can't Grow set to no. It would be easier to figure out if you posted a picture of the design view of the report.

I usually make the user choose his name and week ending on one form, click a button to proceed to the next form and make the defaults or variable point back to the first form. Someone with more knowledge of VBA might have a better way. If nobody else responds, I could upload a sample.

I added a table called tblAgeRanges. If you use a similar table and put this into a form, the users can then change the criteria for the groupings and it doesn't require them to know Access. Check out the new query (qrtChildrenByAreaWithGroups) I've uploaded so you can see how it works. Hope...

I created a form without the drop down box to show you how it could work. Look at qry2 where I replace the field CalcCost with this formula: CalcCost: [quantity]*([rate]*[percent]) The rest of the query works the same. Hope that helps.

It does the same, adds _backup to the file.

Instead of making the entire form read only just lock certain text boxes when the guest logs in.

Create a cross reference table where you have min age, max age, report group. For example min age 0 to max age 3 = 0-3 year olds. Then use this cross reference table in the query to determine which group the children end up. If the 0-3 ever needs to change to 0-4, no big deal to change if the...

Check out qry1 - column called Final gives you the answer. Does this work correctly or am I missing something? I was getting some weird rounding for .25, .35, sometimes it would round down, other times round up, that's why I created the "add penny" column for anything that ended in 5. You'll...

change the record source of your report to this: SELECT DISTINCT tblA.a, tblA.b, tblA.c FROM tblA WHERE (((tblA.a)=17 Or (tblA.a)=22 Or (tblA.a)=23 Or (tblA.a)=27));

I looked at the database, but I'm having trouble understanding your question.

I'm not sure Cronk's results are correct. I came up with 6 customers. 4051 products on the last call date 39 products out of stock and my averages are different. I might be misunderstanding the question. I've uploaded my database with the queries, final answer in Q2_Last.....

Don't think you need a union query. You need to learn how the Totals button works in queries.

I've got an example with Lotus Notes I could share. What email are you using?

Graphs aren't easy to learn in Access, but once you get the one as a template, they are easy to change. I've uploaded a sample for you to use. Couple of things to remember. I always create graphs in a form. For some reason you can actually see a what it will look like in design view of the...

Yes, that's one of the issues with it. The user has to retype it. Maybe someone has some VBA that can fix that.

That's why I said a sample, not the entire data set.

Try it in the database I uploaded and make sure that works. Do everything from the combo box. Don't open the issue form until the combo box prompts you to.

Mine was in 2010 also and I attached a picture to show that it works. What does yours look like?

A form or a report and which one in your database?

Can you upload a sample of the database?