Text(field) Numeric(field) New field (text 00139 139 00139 01745 1745 01745 In my query I want to add a...

i have read many users with this problem but no one seems to know the solution. i have linked tables to an external oracle database. when runnning a query,...

That did it. Thanks a lot. John -----Original Message----- If you mean you want to take FieldA, FieldB, and FieldC and put them all into Field A of the...

How can I print a query (the query itself, not the dynaset) so that I have a paper record i.e. something like print screen. I'm in Windows 98, Office...

I am using Access 97. I am trying to write a query where I need to find out if certain tasks were completed in so many days. I have a received date and an...

Hi, I'm having problem of sorting a string this is the way access will sort 1.2.3.1 1.2.3.11 1.2.3.2 1.2.3.3 1.2.3.4

Hi All. I had found the solution to this a long time ago, but I do not have a sample of it saved anywhere. Basically what I have is this ID InventoryCount 1 ...

I want to pull the right 4 characters from a field named "alpha". This field contains data of various lengths. The field has one of the following in the last...

I have records that contain 3 fields named, "SA1", "SA2", and "SA3". I want to create a calculated field that will look at these three fields and if any of...

Hello World, I am writing an update query that changes a column value for a group of records based on the maximum value of another column. The query...

am trying to build a report that just shows participants with a yes in their combo box for the purposes of a merge document. However, the merge generates all...

Using Window XP, on a word document, I have a table of contents page. I am wanting the left and right margins to be straight, so all text is central without...

Hello All I've not touched Access for several years now, and I've forgotten what you have to do to get around the SQL Date problem when the region is set...

Hello How do I add data from fields in one table to fields in another table? Add Query is not the correct approach as I wish to fill empty fields in the...

I'm trying to get a union query to also be a make table query. Is this possible and where would the INTO clause need to go. Thanks in advance, Ed

I have a table that has the first 8 fields defined as the key. I want to use the first 4 fields in a query as search criteria. This will define all invoices...

I have a data base that contains family information (address, phone, family last name) and then is related to individuals of that family (first name, last name...

I want to sort on a field ("Data") that contains the numbers 0 to 9. Sounds straightforward but the sort doesn't work as expected. What appears to be...

I have a customer table which has all customer ID numbers. I have a second table with customer correspondence. They are joined by ID number. I want to run a...

How could I put restrictions in Criteria for the current year to date in the one field and for the previous year to date in the second field to compare the...