Search results

There are probably better ways of doing it, but you could make the subform invisible until criteria is entered?

Quick Question: why do you have separate tables for each type of order? Could you not just have one table which contains all the orders, with a 'flag' on each record to say what type of order it is?

I had a look on my db at a similar query (which works!) and this is the code I'm using... PARAMETERS [Refreshers Due Between Start Date?] DateTime, [and End Date?] DateTime; SELECT tblRegistration.AttendeeID, tblRegistration.EventTypeID, tblRegistration.RegCompletedDate...

In a form, yes - although it may depend on the version of Access you are using. I'm on 2007, and this is how it works on mine... In the form's design view, right click on the control that you want to format, then choose Conditional Formatting You can add up to 3 conditions... I've attached a...

the key is in your joins... you need right joins in order to show everything from Table3 and any related info from the other tables SELECT Table3.ID, Table3.Date, Table3.Amount, Table1.Owner_LastName, Table2.Tenant_LastName FROM Table1 RIGHT JOIN (Table2 RIGHT JOIN Table3 ON Table2.TenantID=...

try an OR instead of the AND? as in Sum(IIf((Note >=1 And Note <=6) or (Note >=23 and Note<=24), PlateNumber, 0)) Again, not tested ;)

Purely based on the original question, and keeping it as simple as possible, you could just import your spreadsheet into Access as a new table, and then write a query on it to perform the calculations you said you wanted, above... something like in the attached file. However, as has already...

You can use the Nz function to specify what to do if a field is empty... in this case you need to tell it that if [date out] is empty, then use today's date, as follows... DaysStorage: Nz([date out],date())-[date in] or use DateDiff... DateDiff("d", [Date In], Nz([Date Out], Date()))

Had a quick look at this and I don't think what was posted in that forum would work in your situation - it works where you have numbers that are +ve, -ve or zero. Doesn't apply for dates, as far as I can see - they all just come up as the 'positive' value... and you can't specify 'conditions'...

you may COUNT dates, but not sum them....

anything that DOESN'T contain caffeine or sugar - mostly either purified water or RedBush tea at work...

My initial thought: could it be down to rounding?

try using this as your FROM statement FROM Employee LEFT JOIN (Job RIGHT JOIN EmpJob ON Job.JobID = EmpJob.JobID) ON Employee.EmployeeID = EmpJob.EmployeeID Is that what you meant?

had a look at your file but I'm hitting my head on a brick wall, here - why is your form and all the fields on it unbound?

ok that was going to take too long - there would've been 8 years of data to delete! so this is what the form looks like

I was trying not to store it twice.... there's nothing to stop me adding it in, but it means it'd be stored in both the Events table and the TrainerCalendar.... The Main form is based on the Event, with the subform based on the trainer calendar so it can show who is running the course on...

The only 'invisible' ones are LastUpdateDate and LastUpdateBy in all 3 tables.

These are my relationships... If I can't sort on something that's not on the mainform, then could I use a function within the main form's record source to 'lookup' the earliest date from the subform? .. and if I could, could someone please help me to write the function? pretty please ;) (...

:o maybe I'm being thick, but I can't see how? Just to clarify: I want the Events on the Main form to be sorted by the 'Earliest Date' on the related Jobs which are on the subform... even though the dates aren't ON the main form.

Can I set the MAIN FORM ORDER BY to be a field off the subform?