Recent content by jtice01

The query works on its own, but does not work when I attempt to use it as a sub report on the report body. It asks for a parameter. Can you give me an example of what you are suggesting?

I'm building a report based off of multiple queries, which uses a single combo box selection on a form. One of the items I'm having trouble with is displaying a single dollar amount for a particular project selection. The project selection takes place on the above mentioned form. I've...

Yes, I've used this method before. The problem is that it calls the autonumber of the combo box selection, not the text. Nevermind... I figured it out. I just needed to add a column specification. =forms![formname]![comboboxname.column(1)] Thanks.

Hi all, I was hoping I could get some help with my problem. I'm sure it simple but I keep getting errors. I'm trying to add a title to a report. The title comes from a combo box on a form. How can I take the selection from that combo box and pass it to the title? Thanks

I have a problem, whereby, I need to create a query to find people who are unassigned for a particular month. The tables are [Personnel], [_Months], [WorkAllotments],[projects] [WorkAllotments] has the fields: {Person}{project}{-Month}{Allotment} The way it works is that a manager enters a...

That is very helpful. However, I'm still not sure how I can use the comma delimited string as a filtering criteria for a query, which is my ultimate goal. Any words of wisdom there? It would seem like I would need take that string and send it to the query with some kind of macro.

Sorry for this painful first post. I have a normalized database with tables [tblPersonnel] With fields in this configuration {autonumber}{name}{billing_rate} [tblProjects] {autonumber}{projectname} [tblMonth] {autonumber}{_month} This is my collection table for the inputs of a form which...