Search results

Not sure which one of the queries you're looking at but it definitely appears to update the flag fields I wanted in Table 1 based on the corresponding values in Table 2. Mailman - thank you very much for the time you've put into this. Query 3 works like a charm. You've helped me out big style...

Thanks. Does anyone have any ideas about this? I'm really stuck. cheers, Alex

Update values in table based on values in another (w/ example) OK, I think enclosing an example may help me to explain. TABLE 1 has LKTL_CLIENTNO (a unique ID field) plus flag fields S_ASP S_CSTAFF S_CONS TABLE 2 has CIREF (unique ID that directly relates to record in TABLE 1) plus...

But if I just change it to an update query, won't I just be attempting to update the crosstab? I need to link the crosstab back to the flat file so I can update ASP, CONTRACT, etc with the the values produced in the first crosstab.

Thanks for that, Mailman. The first crosstab part is fine, as it displays each ID record with S01, S02 etc fields with flags where relevant. But the for the 2nd part I need to update the flat file fields named 'ASP', 'CONSULTANCY', CONTRACT' with the corresponding S01, S02, S03 flags...

Hi, I've got 2 linked SQL tables, linked by an ID number, and am trying to write a query (not very successfully) that will update a series of Y/N flag fields in one table based on values entered in another. The relationship between flag fields table and the values table is one-many as there can...

Thanks for your quick response Mile...seems to have done the trick

Hi, Hopefully an easy little problem for someone to help me with. Have a table with multiple flag fields (initially populated with either Y, N or NULL). Basically I want to know a way of updating all the Nulls in all the fields with an 'N' value in one go, without having to individually...

That worked. It was 'Max' that did it, but thanks for putting me on the right track, Sam. cheers, Alex

If only it was that simple ;) That would still return a grouped record ID, when one of the contacts had "Y" for [Head_of_IT] What I'm looking to do is return those grouped records where NONE of the contacts has "Y" in [Head_of_IT]. Maybe giving an example might make it clearer, if I had ...

Hi, I have a contacts table made up of records which are a sub-group of a larger parent table. There is a one-to-many relationship between the parent record (company) and the records in the contact table. The records are linked thru a record ID number. The contact table has a Y/N flag for each...

Cheers Charity, That worked a treat. I should learn VB rather than messing around with macros...:) Thanks again. Alex

Hi, OK - the problem is this: Have a main form displaying record details (Company, name, address, etc). Upon clicking a command button, a popup form appears containing filtered records from the main form (just the company name is displayed though). Next to each company name on the popup is a...

Hi, Until recently I have been happily exporting 5 data tables from Access to .txt files. Now, for some unknown reason, I am getting an 'Invalid Argument' when I try to export any of these tables. I'm sure it's not a size issue as a couple of the tables are fairly small. The only workaround...

Hi, I need to extract the first area character(s) from a table of UK postcodes, i.e. B from B7 8TY for Birmingham LE from LE13 6PL for Leicester I know any query/code is probably going to consist of ‘IsNumeric’, ‘Mid’ and ‘Left’ – just can’t get it to work. Any help appreciated. Alex