Hello, I need to concatenate data that I have, the output needs to look like this: GPA:3.7 - Grade: A I have created fields in the query based on GPA and...

My company recently went to a 4-4-5 week calendar fiscal year (28 days first month, 28 days second month and 35 days third month etc throughout the fiscal...

I have a database from an outside source that over time I have added 5 additional fields of data. Each record from the outside source has an account number,...

Morning, I have been working on converting, by hand, a Access 2003 standalone database to a Access 2007 adp/SQL database. I've had considerable luck , and...

Hello, MS ACCESS 2003 on XP PRO. I have a question on group by queries. I have a table that for testing has 14 entries. It's the same ID number (on purpose)...

I have a table that as a list of keywords to search through project names in order to provide common keyresponse. However, I now have an issue that if more...

Hi all, I wonder how the require must look like to add the current row data (as number) to the aggegated sum which is the sum of all the existing numbers up...

Is there a general rule for exporting query results. Some queries the export function is de-activated (greyed out). Some queries the Export function is...

I have a crosstab query that takes about 5 minutes to run. I would like to speed it up or take the hit once and write the data to a table and base subsequent...

i have 3 count columns - count1 count2 count3 count 2 & 3 will only be populated if there is a variance in the previous on hand count. in the end i want to...

Hello, What function in query design do I use to trim all the characters including spaces except the 1st three characters (number)? I am thinking of TRIM...

Hello, I have a combo box that contains two material categories, Metal and Polymer. Based on either selection, I want Query.MaterialSearch to update itself...

I have a query in which I need to calculate running totals on a no. of fields, mainly Year To Date figures. The problem is my year includes the 31/12/07. My...

I would like to run a query for appointments on a particular day be able to click on a particular appointment and for the dataentry form to open at that...

I am creating a data base that will have customers date of birth, and spouse/significant other date of birth. Each month I will need to run a query that...

I have a query that obtains its critieria from a form. Select * From tblData Where Date=!! If no date is chosen on the Form, I want the Date criteria in the...

I have seen posts on this before but cannot find the solution now that I need it - I think John Vinson gave an explanation to somebody previously? I have...

I have built a database consisting of 9 tables and forms for all the various types of tooling equipment a company uses. Each table has a similar field to each...

I have a crosstab query which shows the number of orders for each product over the past several weeks. The problem is that I want it to show the results for...

Hi, I hope someone can please help. I'm a relative novice to queries and SQL, so I apologize if this is too simple a question: I have two tables I want to...