Recent content by Seibert

Adding the Second Eq table worked. Yesterday when I was trying I kept getting a data type mismatch when I was trying to do it with one table in the query. A little sleep, fresh eyes and some good advice goes a long way...Thanks again for your help. ...Chris

Yes the table has a look up field on it. I read that link before and some other stuff before about the drawbacks of doing that. The problem I have about removing the look up field from the table is the auto populating additional combo boxes on a parent form from the first combo box on a sub...

I've seen a lot of discussion on ComboBox showing ID rather than text and ways to fix that, but my problem is the opposite. My ComboBox is showing the correct information but when the DropDown list is shown the first column has the Person's name just fine, but the other columns in the dropdown...

I think I got it!!! On the SubReport Query to have the date from the table I wanted and then put the main table as it's criteria by use of "Int". And then have my Parent and child linked by Truck# SELECT Ex.EqmDate, Ex.EqmTkNum, Ex.CCatagory, Ex.[1120Cat], Ex.EqmDescription, Ex.EqmTotal FROM...

That’s kind of what I have done. I have one point got it to where I have my date range on a query for my report. And then I had query for my sub report asking for a date range. What I ran into was that the subreport query would asked me to enter The date range for the sub report after each...

SELECT Ex.EqmDate, Ex.EqmTkNum, Ex.CCatagory, Ex.[1120Cat], Ex.EqmDescription, Ex.EqmTotal FROM Ex WHERE ((([Ex.EqmDate]) Between ([Forms]![AcctPayDrEst]![PuDate]) And ([Forms]![AcctPayDrEst]![DelDate]))); gives me a blank subreport

Sorry about that; START and END is what is in the query right now for me to select the dates, I've been playing with it (without success) still trying to make it do what I want. I'll need to go back and redo to get it back to the state I had before to try your code again.

Thanks Pat and Arnelgp. Pat- When I tried your method I get a blank sub report and I get a popup box for each record asking for the parameters for the sub report. Arnelpg- I really appreciate the example! but it is not doing what I need it to do. I went in and played with it a little as my main...

I am working on a data base for a trucking company. What I'm having trouble with is a report that will show the information from a job and expenses that were incurred during the job. I have my job information on one table [CompCtbl] and I have the fields [PuDate],[DelDate],[Truck], (I have...

I'm Chris( In Dallas,Texas USA) and I have found the people and the post on this sit to be some of the best. So I decided to join. I would like to consider myself on the verge of being an Access Master, but there is still much for me to learn... "I know just enough to be dangerous" Anyhow I...