In Access you use "*" + + "*", + can be replaced with & Calling a parameterized query in Access requires % be used in place of *, however, all that I have...

Hi, I have a data table like this: ItemID Location ItemQty abc A12B 500 abc B13C 20 abc P11D 50 ead ...

I need to split a single field into 3 fields. I've read other posts regarding lastname firstname splits - very doable. Although not fully understood.... My...

If want to be able to run a query based on a value in a form field eg SELECT PEOPLE.PERSONID, PEOPLE.SURNAME, PEOPLE.FORENAME, PEOPLE.TITLE FROM PEOPLE WHERE...

Every month i receive a new set of data and this helps to populate a pivot table I have created. However, old data can drop off this new list and this will...

In an Access Query, I need to make this telephoen number (555)281-7107 to read like: 5552817107 (no parenthesis or dash) So new to Access and really need...

Is it possible to set up a parameter query, so that you can specify more than one value (ie. multiple "or"). In the case I am investigating I have Access...

This message relates to another subject: "Calculations in Reports" My situation is this: I have a query that counts the number of cases per month, based on...

I have imported data that has names sorted in one field such as Doe, Jane S. I want to convert this to Jane S Doe in a query. Any suggestions? Thanks!

I'm missing something. I'm running a query (below) based on two tables. Values from one table are displaying as expected but not the other. There is just...

I am trying to create SUDOKU table to send someone. Does anyone know how to make bold lines for the 9 squares within a table of 81 squares? -- Geoffoto

Hello, I have a table in my database called OpenTrades. In this table, there are 2 fields I am concerned with, Shares and TransCode. I want to have a query...

Hello, I am trying to create a query that will sum several lines. Details are below, but I am trying to have several occurances of Open Trades from a table...

I am trying to do some analysis on some data I've pulled from an enterprise database. One of the fields contains a character string, and I need to use the...

I am attempting to create a pivot of sorts on a table in Access 2003. In an SQL Database I would use a statement like this: SELECT PARTNO, count(case when...

I typed the following expression in the query field. the result is ok. However, I can't get the field to format to four decimals. MSI Costs: IIf(="","",/)

Time Cards Subform is in the Time Cards Form. The subform automatically updates the Time Card Hours Table. The subform elements...

Hi Is it possible to run an access query to insert records in an access table from a table in a remote sql server db? Thanks Regards

I am making a Database with client occupying a room at a date (Date In) and leaving the room at a date (Date Out). I need a report to list which client is in...

I have two tables: Requests, Suspects with inner join (by request#) I want to run a query by case number (a field on the requests table) and show all the...