Search results

I have a field - Period in the format YYYYMM. How can I split this value so that I only extract YYYY? Thanks P

I have two field columns For example: Field 1 Field 2 -------- -------- Blue Blue Red Red Yellow Black I need to write a select query that will output any rows where field 1 and field do not match. How can I write this? does anyone have...

Apologies had not linked to loaded form. Parameter box not appearing now, however the selection does not filter by company code. Can you help?

Thanks for your reply. The field seems to be fine. Could this be something to do with the settings in my criteria within the query?

Thanks for your reply. The field seems to be fine. Could this be something to do with the settings in my criteria within the query?

I have set up a form that picks up reports from my database. The structure of this form is: Select Company Code Unbound Select Report Drop down list of reports linked Year and Period *** The company code refers to 5 different company codes. The report is then linked to a select query...

I am trying to create an MDE file from my .mdb, but receive an error "Unable to create MDE file". Can anyone suggest how I can find out why this cannot be created? Thanks

The purpose of my query is to select employees pension dates by date range. The structure of my query is split into 2 queries. The first pulls data direct from a benefits table. The pension date is in the format yyyymmdd. If I add: Between [Forms]![Benefits]![date1] And...

Thanks for your reply. This would be fine for a one of date search, but for end users they may wish to set the criteria for different ranges. Thanks

I am trying to extract records within a certain date range. My structure is as follows: Query 1 = pulls data direct from a table. There is a date field which is in the format YYYYMMDD. Query 2 = pulls data from Query 1 and amends the date format to: dd/mm/yyyy Has anyone any suggestions on...

I have a field within a table entitled "Name Display" This displays names in the format: Surname,forename I have used the following: Full Name: Right([Name_Display],Len([Name_Display])-InStr([Name_Display]," ")) & " " & Left([Name_Display],InStr([Name_Display]," ")-1) To rearrange so format...

I have set up a query to pull data from within a date range. I have written an SQL Statement to amend the format of the date field: Effective Date: IIf([Date_Effective_From]="00000000",Null,DateValue(Mid([Date_Effective_From],7,2) & "/" & Mid([Date_Effective_From],5,2) & "/" &...

Thanks for your reply I have found a solution. If I type in: 1 AS Line_No 2 AS Line_No etc etc at the end of the select + union statements, all lines will report. Thanks

The summary of expenses if by week number and by employee. i am trying to summarize these additional expense details into one column, however using the SQl code I have written the query misses some of the data. I have used UNION ALL however via the full I receive several entries per employee...

Unfortunately I do not have full control over the table. I am using linked tables to a main server held elsewhere.. Abit confused about what you mean - that could be down to Friday afternoon. :-) thanks

Thanks for your reply. The report I am running reports on additional expenses incurred by Temps on a weekly basis. There are some underlying queries - A base level union query that pulls together these 3 seperate fields from a table and combines them into one column so for example: Table...

Many thanks for your reply. I have individually tested each statement and they all work ok. So presentation it seems does need some altering. Do you have any suggestions? Thanks

I have created a report that provides me with employee expenses for temps per week. The types of expenses have been defined as Ad_hoc amounts. An SQL union query I have used to combine fields Adhoc_Code_1 - 3 Adhoc_description_1 - 3 Adhoc_Pay_Amount_1 - 3 (details of full sql query...

Can anyone help? I am using the following expression which assumes: Start is start date field name (be sure to use the actual field name) Leaving Date field name (ditto) Current employees have a blank end date All employees have a start date To return the months of service for one year at...

Thanks for your reply. I have tried to calculate the difference in months between Start Date and Leaving Date: months paid:datediff("mm",[Start Date],[Leaving Date])