Search results

Thank you for giving this a shot. Unfortunately, this way is still giving me an error... And thanks for the advice on saving the subqueries separately- I always try to do that, but somehow end up into trouble with syntax when I try to put it together in the main query...

Hi Big Pat, thanks for your reply. I realized that the square brackets were a problem, but replacing them with regular brackets didn't help either. I abandoned ship on doing all of this in one query and decided to add the FY12 and Previous select statements as sub-reports in the main report...

:confused:Hello, I am working in Access 2003. I have a Vendors Table and a PurchaseOrders table in a one to many relationship, though not every vendor has a purchase order entered so far. The purchase orders tracks the fiscal year in which a PO was issued through BHSRequisitionNum. What I want...

Thank you Paul. I decided to go about just as you suggested.

Hello, I am working in Access 2003. I am creating a budget database that will be used for reporting purposes. There are three types of employees in the company: regular full time, temporary, and contracted workers. Some of the fields which I need to capture for each type of employee will be the...

Hello, I tried that before and it returned only the vendors which had an order entered in 2012- just like an inner join would. However, I did figure this out- and it turned out to be something ridiculously simple. I used IIF() to define the Spent and Closed fields and put in the...

Hello, This is my first post, please bear with me if it is too wordy. I am working in Access 2003. I have a Vendors table and a PurchaseOrders table in a one to many relationship. The PO table holds, among other fields, the amount of each order, amount closed (paid off) so far (some orders...