Search results

I have a table with Sales Dates and Sales Price and I am using a Running Total Query to chart our Monthly Sales by Day. I've placed the chart on a form and linked it with a Combo Box for Month and text box for year to view each Month individually. My boss wants me to add a target line to this...

Hello, I am creating a line graph from a running total query to show our income from items shipped for each month. Currently I have the following Code in my query which works but it displays the month as a number in my graph and I would like it to show the Month name. SELECT...

:banghead: I've tried this so many ways and each time I get almost where I need to be. Right now I have a bound subform that lists all of the relationships from my unbound txtJobNum control and I can add and delete lines from the table directly on the subform. What I really need is to NOT...

I'm trying to make a subform that the user can select which items will go on the invoice. I've been looking at the Northwind db and their "Purchase Order Details" form has the subform I want; however, when I set my form and subform up like theirs, mine shows all of the records from my...

What I was looking to do was to make my query show everything including Nulls when there was nothing in txtCustomer and to not show nulls when there was something in there. I came up with this: WHERE (tblCompanies.CompanyName) Like "*" & [Forms]![frmSearch]![txtCustomer] & "*" OR...