Search results

Many thanks for you additional assistance. The item b) will require some considerable thought for someone with my limited capablities. The date problem seemed more straightforward. I substituted [Mail List].Subdate for my specific date of 01/01/2014, but it didn;t work. The query ran, but...

Minty, I have followed your advice and produced the following SQL which works beautifullyl UPDATE [Mail List] SET [Mail List].[Renew/New] = "R", [Mail List].[£ Recd] = 0, [Mail List].SubDate = Null WHERE ((([Mail List].[Renew/New])="R")) OR ((([Mail List].[Renew/New])="N") AND (([Mail...

Thanks Minty, I shall try again based on your suggestion. It seems so logical, now that you have suggested it. jcbhydro

Good Morning, My Membership Database includes 3 fields in the main Table which I need to clear prior to the new subscription year, but on a selective basis. The fields are R/N for (Renewal or New), a subscription date and an amount field (Currency). At the due date I need to clear all 3 fields...

Hi there, It is not correct that one cannot have more than one 'SELECT' or 'FROM' in an SQL statement. I have now succeeded in combining the 2 SQI statements which includes duplicate 'SELECT' & 'From' statements, The revised SQL performs precisely as intended. Quote SELECT a.[Member ID]...

Good Afternoon, I have attempted to combine and modify the SQL statements as suggested, but I get a persisting syntax error highlighted on the second 'Select' statement. I assumed that was due to a mismatch of ellipsesm but I have failed to find the error. SELECT a.[Member ID], a.[Address 1]...

Thanks for the comment, I shall play about with the SQL coding and see what happens. jcbhydro

I don't understand your 'failure to understand'! It is quite possible to combine 2 elements without amending the individual elements. If I combine steel with concrete I get reinforced concrete, yet neither the steel nor the concrete have been amended. My question was very simple. Is it feasible...

Good Morning, I have 2 queries serving useful routines, one to filter out duplicate addresses for a mailing label routine, the second to convert tick boxes into Y/N answers for a Tab Delimited Text file export. My question is; can I combine the 2 SQL statements in the 2nd query without amending...

Uncle Gizmo, I would be grateful if you would amplify on your statement that the 'text of the associated Member name can easily be obtained'. This easy routine is not entirely obvious to me. I am still puzzled as to why a form field calling for a 'Leader name' displays a 'Member ID'. Regards...

Thank you for your comment. My point is that the form is requesting the display of the Leader'MemberName' but it is the ID which is displayed. jcbhydro

I have an entry Form which is used to record prospective new members of a society in a Table named 'Foreigners' in a Membership Database using Access 2010. The entry form also records the name of the 'Interest Group' to which the prospective member is initially affilliated On entering this...

Problem solved! Not a mistaken entry, but a very ambiguous coding instruction. The Export with formatting routine has a line which reads; Output Format for which I selected 'PDF Format (*.pdf) The next line requires input of the path and filename, for which I input a series of filenames such...

Gina, 2010 Version. jcbhydro

Gina, The Macro was created as part of the database using the 'create macro' facility from the toolbar. Does this make it an Embedded Macro? It is not a Web Database. As explaaned I did a simple copy and paste off the 'Export with Formatting' section of one of a series of some 25 identical...

Good Morning, When I copy and pasre the 'Export with Formatting' section of the Macro, this is what results. This bears little resemblance to the code shown in the Macro itsef. Is the cut and paste procedure the correct one to produce what you want to examine? <?xml version="1.0"...

Good Afternoon, I have constructed a Macro which works fine to export a long series of files from database tables for circulation to some 50 recipients. The Macro incorporates the expression Export with formatting and output format has been selected as 'PDF format (*.pdf). The macro produces...

Thank you for the comments. I hadn't appreciated that a 'delete query' in Access is limited to a single table. I'm sure that wasn't the case with DBase 3 or Lotus Approach. Your first suggested code didn't work for a separate 'Delete Query' with the 2nd Table GroupMembers. However, the second...

Thank you jdraw for your response to my problem. I see the logic of using INNER JOIN. However, unfortunateley, that alone doesn't solve the problem. I stll get the message 'Specify table to be used'. On the subject of SELECT v. DELETE, SELECT is not relevant in this case as I run an Append...

I have a 'delete query' to remove 'leavers' from my main table [Mail List]. It works well. I have another table [GroupMembers] from which I require to delete relevant records of 'leavers' simultaneously. Can anyone suggest why the following SQL code fails to work. It brings up a dialogue box...