Search results

Should work, can you post up your db?

You need to have the form open when the report runs, so the report can get the data from the form

Try putting ; at the end of your SQL statement

In your form you could use the Replace function, make the first address text box invisible and add another text box with the control source like this =Replace([nameofField],",",Chr$(13) & Chr$(10)) The Chr$(13) & Chr$(10) put the carriage return line feed in

Great glad it worked :) I think you would need to use VBA to strip the string from the memo field, and I'm not sure about how to do that, sorry.

Hi, I think you need a update query and a form to enter your word, so that you enter e.g. Chesterfield only once. In the query using the criteria under your memo field of Like "*" &[Forms]![NameofForm]![nameof textbox] & "*" and then in theUpdate To of your furniture column put...

Will your memo field in your eg only include Chersterfield or will there be other text held also?

Youre welcome, glad to help.

Create a totals query, put the source field in twice, under one use group By and under the other put Count. Add your dateofcall field using Where and sets it criteria to Between Forms![nameofyour form]![start_date] And Forms![nameofyour form]![to_date]

This will identify those people that dont attend (replacing Table1 with your table name) SELECT Table1.Name, Table1.Date, Table1.Required, Table1.Attended FROM Table1 WHERE (((Table1.Attended)<>[Required]));

I would use an update query to update the hire dates in your new employee data table. Join the old employee table and new employee data table as you described by name and dob. You could also use an append query to add records of those employees (the terminated ones) that exist in the old...

Is what you are trying to do is to calculate a total for each membership no in each of the eight files, and have that presented in a single query? If so put all your 8 tables into a single table and create a totals query that groups on file no and membership no and sums on amount.

Thanks Brian, That works (so simple, I was complicating it) and and thanks for the tip on spaces.

Thanks, thought it would require VBA

Hi, I am currently working on a project where i need to try and compare a list of organisation names held by my organisation and another organisation (around 20000 records each). To take into account differences in how the organisation names may have been entered I'm wanting to strip out...

Thanks for that Brian, done that and rejigged the brackets and its now working. Code is

Im currently trying to create a field that strips plc and ltd suffixes from vendor names, and if theyre not there just return the name. I've tried the following which works fine for those records where plc or ltd exists in the name, but where it doesnt it's returning error. Can anyone point...

Glad to help

Sure, use DoCmd.Close acForm, "Add New Invoice" after the open form command It needs to be after the open form as the open form needs to pick up the value from the add new invoice form when it opens.

Adding a DoCmd open form command to your existing code like below should work. If (DCount("[Invoice Number]", "Invoices", "[Invoice Number]=Forms![Add new Invoice]![Invoice Number]")) Then MsgBox "This Invoice Number has already been entered. Please check the invoice.", vbInformation...