Search results

Wow, passive aggressive. If you had nothing constructive to add it would have been better just to not reply. Good luck with your life.

Oops, I pulled all the data out of the tables to post the database for data protection reasons. The queries return exactly the data I want, the problem arises in my chain of queries when it comes to looking up the data from the qualifications table. I need to figure out a way of joining those...

I've managed to solve a lot of problems in my database on discovering subqueries. Now I've got and input form based on a table with a subform based on a cascading set of subqueries. This all works fine until I have to define the relationship between my subqueries in the query field criteria. I...

So I solved my problem with retrieving the data using a series of cascading queries of queries (subqueries?) I based my main input form and subform on those queries but now I am getting a 'This recordset is not updateable' error when trying to input into the form. I changed the recordset of...

Ahhhhh, queries of queries. Down the rabbit hole, this looks like the right direction...

This database is to be used to store all the data for a sports education provider. The [tblLearnerDetails] stores a record for each student (actually, each student can have more than one record if they leave and return for a new period of learning). Each student can be on multiple aims...

Ok, I've cut a lot out to get it under 2Mb but enough of the relationships are still there to show my intent. I think this is an issue with how I've set up the relationships as the full relationship structure breaks my queries. I've been working with a stripped down structure but when I try to...

I have put the 3 fields: [fldPSCNQNWindowNumber], [fldPSCNQNWindowStartDate] and [fldPSCNQNWindowEndDate] from the [tblPSCNQNWindowNumbers] table into the query and put the following line into the query criteria of the [Planned End Date] field: Between [fldPSCNQNWindowStartDate] And...

I've just read somewhere: "All referenced fields and tables must also be present in the saved query. Plus, each field should be precisely specified by a tablename. And "external" values (e.g. a textbox on a form) must be concatenated into the criteria expression." I remember now that the last...

Ahh, as you can probably tell I've been using Access for all of a couple of months being the most tech savy in my office the task has fallen to me to update our data systems from Excel. I have been using the expression builder to write my query and the full form control reference is what is...

Hi, thanks for your suggestion, I didn't have a chance to write proper reply the other day. I removed the spaces but haven't had a chance to test it out. For the Format() function I've used the ISO standard format which should work as well as the US one. I'm going to do some more work on it now...

Ok, so I'm having some trouble with a DLookUp function which is driving me insane. I have an input form which is based on 2 queries. The queries are called [Learner Details Query] and [Aims Query]. The tables are joined so that each learner record in the [tblLearnerDetails] can have multiple...