Search results

Thanks PLog... I very much appreciate the input. I will look into that. :)

Can a table in Access be set to allow updates but not add records? Or would I do that in a form and always set the current record to 1?

OK... got it. That makes sense. :)

Well, there are quite a lot of views from the managers point of view so having them put in a date for every report would make them crazy. Is there a way to set a constant in Access that can be set and changes once in a while but normally loads every time you open the database? That way, I could...

Hello all, I am crafting a ridership database. The database collects data about bus trips and reports totals to the state on a set annual cycle multiple times a year. Those dates change from year to year depending on the dates the calendar committee set for the coming year so I added a...

Thanks June7... I am working to keep the users from direct access of the data. Locking this down will be a future question. :)

Got it... THAT was simple. So much to learn still but that really helped. Thank you I owe you a libation of your choice now...:D

I am already summing on that report. It is totaling all the trips per day. I need it to sum up all the data by column now. Sounds like I need to delve into reports next.

Syntax error initially. But you led me in the right direction. It is now working. :D

Hey all, Another beginner question. I have a simple query that pulls trips by bus by day and totals the trips for all buses by the type of ridership... i.e. basic, sped, etc. How can I make the table show totals at the bottom of each column so we know what the totals are for the year? The SQL...

As in below? TRANSFORM Count(MileageBreakoutByVehicleQ.MaxCount) AS CountOfMaxCount SELECT MileageBreakoutByVehicleQ.VehicleName, MileageBreakoutByVehicleQ.VehicleID Sum(MileageBreakoutByVehicleQ.[Total Miles]) AS [SumOfTotal Miles] FROM MileageBreakoutByVehicleQ GROUP BY...

MialageBreakoutByVehicleQ is the first SQL code above.

Crap... not sure what happened to that post but only half of it is there?!? The question is I can't figure out how to get the crosstab view to sort by vehicleID rather than alpha-numeric. The SQL for the parent query is SELECT Trip.[T-Date], Vehicles.VehicleName, [Trans-Type].Code...

Hey all, I have a cross-tab query (MileageBreakoutByVehicleByCode) that I crafted from a filter query (MileageBreakoutByVehicle includes the Trips and Vehicle tables). The filter is sorted by vehicle ID which puts the data in a nice ordered format as such. VehicleID is from the Vehicle table.

Thanks all... that did the trick. :)

I have the bus select form doing a simple view of the Vehicle table. If I remove the sub form, you just see the vehicle records and use the nav buttons to move through each record to no lookups. I initially tried to do a combo box lookup where I select the bus I want to review but then the...

Hey all, I thought I posted this last night but I can't find it here so my apologies up front if this is a dupe. My first foray into Sub-forms so bear with me. I have a form (Frm_BusSelection_Review) tied to the Vehicle table. the subform is Trip Subform (Image attached along with the...

That did the trick. Steep learning curve for me. Didn't know what the Nz() function did, now I do. :pThanks Folks...

Hey all, Still working on a ridership database and doing entry checking. I have DepartTime and ReturnTIme. The DepartTime must be > zero. When the user puts in Return time, I am checking to see if it is > DepartTime with the following AfterUpdate code entered. The check works but if they do put...

Thanks CarlettoFed... :)