Search results

I have a large number of calculated text boxes in an Access 2007 report that I want to apply conditional formatting to for more than 3 conditions. I have been trying to use a Collection to allow me to loop through the text boxes and apply the formatting. I have the following code attached to...

Hello, I've got a concatenated field (we'll call it [Report]) in a report that I want to shrink, allowing lower fields to move up, if a given field in my report record source (we'll call this [Source]) is null. How can I do this? Thanks

I've made several posts about this in the last few weeks and am getting closer to the solution, but the deadline for my project was last Friday and this still needs to be done. I have the following fields in a table named EventSchedule (compiled from normalized tables via append queries)...

Every time I run the following query: SELECT SchedRepQuery_1.LicensePlate, SchedRepQuery_1.VehicleName, IIf((Count([SchedRepQuery_1.Event1]<>"-")=1),[SchedRepQuery_1.Event1],(IIf(Count([SchedRepQuery_1.Event1]<>"-")>1,"CONFLICT","IDLE"))) AS Expr1 FROM SchedRepQuery AS SchedRepQuery_1; I get...

I have a series of events that have a start date and an end date. How do I write an append query to append an event to a table as an individual event for every day in the given range?

I am trying to design a report that uses a range of dates as column headers. The row headers are vehicles and the intersection between the columns and rows will display details about that day's vehicle usage. To do this I need a query that will produce a row of date headers based on parameters...

I am building a database for a vehicle rental service and need to build a report to display the vehicle schedule. I want to use dates as column headers and list the vehicles down the left side of the report. At the intersections I need to list the name of the customer and the driver assigned or...