Search results

Hi, Each record has a certain number of outcomes that are stored in a single column delimitered by a full stop. I can split these out in Excel and create a link table. I want to put all the outcomes in two fields (outcomeA and outcomeB). This is the query for the first outcome... INSERT INTO...

Hi I work as a performance data analyst in local government and report from a system called E-start which is used by children centre administrators to record attendees at their events. One of the reports is for event outcomes. Each of these outcomes are compiled into a single field and...

Thanks both but I don't need to make it complicated.

Thanks for this but I want to stop the loop as soon a query returns no records if possible. If it isn't not a problem

I have an excel link table and 24 of the columns are named "Attendee outcomes1" to "Attendee outcomes24". The following query is a much shorter version (but this is essentially it): INSERT INTO tble_record_comp ( ListNo, FamilyID, MemberID, Attendee_outcome ) SELECT Import_Link.List...

Hello, The database I have created is totally Access and I split it with an Access BE. I have in the past used Access and linked to SQL server just to download information but there was no need to update, delete and add records in the tables. I know of the upsizing wizard to create a SQL...

American politicians consider America to be the exceptional nation and everyone is out to get them yet who ends up being the bully!

The specific records are for recording work history (company, job title, start date and end date). I had originally thought that recording the three most recent job positions would be enough (going back to the beginning of 2011) but that is arbitrary. It depends how long they were in the job...

Hello, I have a table that records a list of dates using the first of the month in short date format (01/01/2011) and I have the following query SELECT Format([dateworked],"mmm yyyy") AS Monthyear, Table_dateworked.dateworked FROM Table_dateworked; This query is the source for a combo...

Help appreciated, thanks.

I have attached a db with two tables and their corresponding form and subform. When I enter a record into the form and open the subform I would expect the corresponding "cand_ID" number in the subform to appear but it remains zero. BTW, I've never really used linked subforms so this is a bit...

Yup, that is indeed what I want to do but the record is not saved if I press the subform button while in the record. So presumably the record needs to be requeried or saved in some way.

What is the best way to open a linked subform using a button while in a newly created record? I thought a simple docmd.save command would do (either in the "current record" or the "after update" event) Thanks

I've decided to take out the date of birth and simplify the query.

In SQL Server, the tables are not connected but are created using SQL (which has been my experience anyway). Does having established table relationships in the BE create problems for performance and speed? I am wondering whether it might be better to have separate tables in the BE of an...

How does this work?

ok. Is it also possible to have tables in the front end as well as the back end?

Hello, I have a database with 14 tables which I set up for a small local recruitment company. As you can imagine they do a lot of adding, updating of records as well as doing searches. I split the database into a back end with the tables and a front end for each consultant with the forms and...

Thanks, as always.

It does make sense. Q1. How do I access this autoexec macro? Q2. How would I insert the sent date?