Search results

Guys, This is where I think you may have a snigger at me. I have setup a database from a single table, and split this up into a number of one-many relationships using the Table Analyser wizard. This has given me all the functionality i need to be able to generate the outcomes I need. However I...

I have 2 queries that are identical, except one returns the value where Affected = Y and the other where Affected = N. I then tie these two together in another query by relating them using a Region field. However when I run the tie in query I get a problem when the affected = N query returns...

Guys, I have a from where i select some values(including a code) and then produce a query filtered by these values. From this i need to save the filtered query as an Excel spreadsheet with filename = code. TransferSpreadsheet seems to eb the answer but I can't get it to modify the filename by...

Guys, I have a table with a field in which the data is of the form: 0 Day(s) 0 Hr 2 Min which is formatted as a text string. I need to turn this into number values so that i can perform calculations on the data. How can I do this so I can run a query where I sum the values of the field...

Guys, I have a table with a field in which the data is of the form: 0 Day(s) 0 Hr 2 Min which is formatted as a text string. I need to turn this into number values so that i can perform calculations on the data. How can I do this so I can run a query where I sum the values of the field...

I have a table where records are entered and one of the fields contains a date/time in the form 27/04/2004 13:51:00. I need to create a query where the results are filtered by month, the month having been chosen by the user from a form in the step before. How do I get the filter to connect the...