Recent content by Go3Team

Ive got it temperarily(spl?). Had to do a query for each one.

I am trying to do a report that lists 2 different entrys from the same table (or query). But when I do the wizard :/ it only lets me pick from the table or query only once. How do I go abt having the program differentiate between the two entrys and list the data I want listed?

You have mail. Thanks.

Still stumped. I ended up having to put [Enter Starting Date] and [Enter Ending Date]. The problem I'm having now, is that I dont want to have it grouped by dates. I have it GROUP BY because I need to figure the sum of all miles traveled in each state. The date function is there because Miles...

I am checking the total mileage traveled in each state during a particular quarter, for fuel tax purposes. So the date query would be for example: 1/1/01 to 3/31/01 or 4/1/01 to 6/30/01. But the people using this would not know how to edit the query to perform the function, which is why I want...

Would this be a correct Criteria: > [Forms]![State Mileage Finder]![Starting Date] And < [Forms]![State Mileage Finder]![Ending Date] ? Edit: Didn't work. [This message has been edited by Go3Team (edited 11-19-2001).]

Looking to make a query based on dates entered into a form. Here is what I have and its not working: SQL View: HAVING (((Recap.Date) Between [Forms]![State Mileage Finder]![Starting Date] And [Forms]![State Mileage Finder]![Ending Date])); Here is what I entered into the Criteria field in...

Trying to do this, with no luck. I'm trying to design a dispatch software for a small trucking company and trying to be able to put the pick up and delivery locations in one table, because at one time or another, the locations will either receive or ship. But when I go to make the form, the...

To input data from a record automatically by entering an ID of some sort, I think Im making progress, just have to refine it a bit by taking out the repeated entries

I tried doing the combo box, and third entry but then I had to click the down arrow to put the down arrow in the field how do I get around that?

I am trying to design a form, so that when I use the drop down menu to choose a customer, it automatically fills in the address, city, etc. I am trying to do it like its done in the example db. (The Northwind example, under the orders form)