Search results

So is there any way of having multiple criteria referencing the same field without repeating the field name each time?

If I put an Iff statement into a Query such as: IIf([Table A]![FieldName] Like "A" Or [Table A]![FieldName] Like "B","Answer A", "Answer B") It works ok but as the table name is the same why do I have to repeat it. If I try: IIf([Table A]![FieldName] Like "A" Or Like "B","Answer A", "Answer...

Great - Thanks

I have designed a report based on a cross tab query that counts the number of units sold by each dealer per month. So the left hand column lists the dealer and the rows along the top list the months. There is then a total at the bottom. This worked find when I was reporting on an entire year...

I need to export the results of the queries as they are sent to a client in Excel format on a regular basis. This is a large and complex db with lots of queries that just get exported to Excel spreadsheets for the client to look at the data.

I have a simple function that says: DoCmd.TransferSpreadsheet acExport, 10, "QueryName", "C:\FileName.xls", True, "TabName" I want to export 5 or 6 very similar queries and I am concerned that my database is starting to just have way too many queries to be manageable. Can I replace the query...

Hi Not sure I understand. Not really a programmer but doesn't wend need a while and isopen need to be defined? Do I just repeat the code you wrote and change the report name each time? Basically I just want it to open one report then the other, then the other etc until they are all open. I...

I have a series of 14 reports which I need to preview and then print. Rather than do them one at a time I would like to open them all in preview mode at the click of the button. All the reports preview fine if run one at a time or in batches of 3 or 4. However if I run a batch of 14 it always...

I am using: RetVal = SysCmd(acSysCmdInitMeter, "Preparing Database...", 5) in order to display custom messages on the status bar. This works fine when I test being able to display this but when queries are running then the standard Status Bar saying Running Query etc over rides my custom...

As part of a long series of import routines I use the function: DoCmd.DeleteObject acTable, "CH32310N_ImportErrors" to clean up tables. However I have to have one of these statements for each table error table. Is it possible to use wildcards within this function to say for example...

Thanks for offer. Managed to sort it.

I have created a pivot chart and changed the bar colours via the properties but when I add a legend the key uses the default colours not the updated ones???? Any ideas???

Many thanks and my apologies for the breach in protocol

I am obviously being really stupid by the query below compiles ok but when I run it I get a syntax error. Its a long query so it is split up with " & _ Any help would be appreciated.... DoCmd.RunSQL ("SELECT [Bounce Backs To Process - Imported].ID, [Bounce Backs To Process - Imported].Contents...

I am obviously being really stupid by the query below compiles ok but when I run it I get a syntax error. Its a long query so it is split up with " & _ Any help would be appreciated.... DoCmd.RunSQL ("SELECT [Bounce Backs To Process - Imported].ID, [Bounce Backs To Process -...

Great thanks.

I need to strip out everything before the last space in a string. I can use the Instr function to find the position of the first space but cant work out how to use it to find the position of the last space? So if I have the text "This is what I want" the query should return "want" Any ideas???