Search results

I searched online but I'm not sure if I need to create 3 separate cosstab queries and then somehow join them. I'm trying to achieve a report that will show a percentage of 3 criteria (checkboxes) based on month. I'm following some tutorials but I'm unable to add 3 values in one crosstab query...

Thanks, I appreciate it. I realize now that vba help requires exact parameters so an example database is helpful. Can someone point me into the right direction here : So I'm trying to implement this using the helpful resource that I can't link because of insufficient points. "How to Create...

Ok. I clrealy notice that you all think I didn't put that much effort and what I'm trying to do sounds easy to you so I'll go ahead and show you my thought process while I go through the 10 examples you linked. 1. Custom AutoNumbers Do I really need to use a library with 500 lines of code to...

Whelp, here we go. Thanks for linking the access manual but I do know how to google and looked through the results but my access skills are rusty so I can't really find out exactly what I need if I don't look at a specific example.

Mark, I do have a copy of the Project ID in the ProjectActivities. It's set as a foreign key. I don't understand how would that be an autonumber. It's an autonumber in the Project table, it can't be an autonumber in both. The real example I have is way more complex than what I presented here. I...

Hi, Thanks. Were you able to find links? I searched but the examples are either way to complex or doing something that isn't what I'm trying to do (i.e incrementing already an existing ID which is not the issue in my case). For me the ProjectNr is already known and only the activityNr needs to...

I'd like to improve the data entry for a form so that fewer mistakes are made when entering this number. I have two tables. One is Projects the other is ProjectActivites One Project can have multiple activities. I have a form that shows a Project and in that form I have a subform that shows...