Search results

Actually got back to finishing that part of the database today. Took me a minute to tweek it into working but it does work like expected it to. Thank you so much.

Yes just like that, could I get that so I can dissect how you did it?

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...

Wow, I feel dumb, thanks David R

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...

Thank you so much, now that you have mentioned that, a temporary table should serve my needs perfectly.

: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 didn't have the Master/Child fields set and I realized, after realizing that, that I was trying to do this all wrong anyway. Thank you for the help though.

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...