Hi I have an access database (2k) that imports data on an hourly basis from a Dbase application. When i run each of the import/append queries...

I have set up a form which includes an input mask on a date which concludes with it in the following format "Month Year". I now wish to run a parameter query...

I have a make-table query which consists of all the fields of an existing table plus an additional 10 columns. Each of the additional 10 columns has a custom...

There are several fields stored in a field for guest information that I need to format. Specifically, Zip Code and Phone Number. Both fields are stored as...

I have information from a query that i need to sum in a report, this is what the query returns 7A0001 2 7A0004 3 7A0301 4 7A0302 9 7A1001 ...

Access 2000. I have table of many hundreds of records. One of th fields of text looks like this: XXXXXXXXXXXX and I want it to look like this: XXX XXX XXX...

Working in a large workfile with worksheets that are linked. Formulas were calcing fine and today stopped auto calcing and only cal when pressing F9 over and...

Hello, I would like to show in a query the time formatted to look like: HH:MM A or P In other words I want to show hours and minutes followed by an A if...

I'd like to convert text to int to retrieve bad records. The records are basically Last, First, ID, Img#. All Img# will be either a real number, or a text...

I have a table of actual dollars spent with project numbers and categories. Some of the categories are incorrect. For example... Project 1 has a category of...

Can someone please help, this is driving me nuts I have 2 querys with the following fields "Work Orders Query" , , "Work Order Materials Query" ,

Hi, I am looking to combine two tables. Both tables have one column with the same name but all the other columns are different. The column with the...

I am trying to send out Quarterly statements based on the issue date of the contract. I just need to know how to update the Next Statement field with date of...

I am trying to do a select query on one table. This table has many records with a DATE type field in each record. I would like to select all records from the...

Hello, I have a field called Given Names and it includes both the first and the middle name of a customer. I would like to break the two names...

I have two tables a main table and another we'll call Table 2. I joined them so it says "all records from main table and only records from Table 2 when they...

I have a report (just a simple table) that I've created from a crosstab query. I've included all 'columns' in the report, but all the columns are not always...

I wrote simple select query in a database I maintain this afternoon and the query is returning multiple copies of the same record, 522 copies to be exact. The...

I have a database which includes a table of carton descriptions. The table has two columns - ID and Description (as below) ID Description 1 02*936 +...

Hi I have a sub form with a field called shop number, I have a query but would like the query to (after clicking a button) use the shop number to populate the...