Hello, I am formatting data that will be imported into another softward package so I need my query to appear in a specific format with five columns....

Hello, I could use some help with "if" conditions as I need to separate dollars by the first character within an account number. Example-Table: Field 1 ...

Hello, I need some help reformatting data within a query. Here's an example of my situation. Table 1: Field 1 (Month): 4 Field 2 (Year): 2008 Field 3...

I realize that this question is not strictly "on-topic" w/r/t this NG; however, it directly affects participation in this group. Several of the larger...

I have a form that uses a query linking 4 tables as it's data source. We are trying to convert all of our data tables to an SQL server and now my form won't...

I have the 60-day trial version of Office 2007 and am having issues with Access 2007. When I create (or attempt to modify) queries of tables in a split...

I have a main table called Reports. In it I have a Staff PIN and a Supervisior PIN. I have another table that has all the PINs and employees scanned...

I have created a data base in Access 2003 that when in the form object a parameter quesry will run without any prompting. In looking at my design I am...

I have an end user asking for a list of all records grouped by week. In other words datasheet view of the records grouped by week with a space between the...

I tried to union 2 crosstab queries with same fields output, but Access complained syntax error. I just wonder does Access support union crosstab queries? If...

Here is my issue. I have a table (emp) that contain fname, lname, DOB (date of birth), DOH (Date of Hire), Seniority, and SS (last four of Social). ...

Hi all, I have a group by query with two fields p_code and cost_code that I need to calculate the median on the weight. I'm running into trouble because the...

Is it possible to run a query or open a "Make Table" from a form? I am new to ACCESS, and I would like to use a COMBO or LIST box to select the search...

I am working with data where the records that were no longer valid were altered to have and astericks in front of the last name. Since an * is a wild card, I...

I have two tables, 1st- Part Table Build, 2nd- Manual Price Overrides. the 1st is created from a make table querie, the second is a linked excel worksheet. ...

Hi I have finally managed to work out how to rank the results from a MI Quiz, however I cannot work out how to avoid having to scores equal. i.e. 2 in second...

Hello, I have a query that we haven't used in quite a while. We need to open it and change it so that it's active for this year-- currently, it's set on last...

HI, I have strings like 202/05/10 51/15/20 205/1/1 I would like to extract the numeric part of the strings Pls help

I have a database for several different cities. The databases are identical except for their title. I am trying to combine the results of an append query...

I have tried to use the product key supplied with this brand new ASUS computer but all I can get is incorrect product key, so what can I do?