I do not want them combined to one field, sorry.
Here is what the query looks like now:
Case Number 5 Fields from the Many Table 20 Fields from the One Table
507-111
507-111
507-111
etc.
The 5 Fields from the many table are different for each case number, but the 20 Fields from the one table are the same for...
User Profile
Collapse
-
There is no grouping involved.
I have two tables:
Ex)
Main Table
Case # Other Fields
112-112 blah blah blah
Other Table
Case # Other Fields(not the same as the main table)
112-112 blah
112-112 blahh
112-112 blahhh
112-112 blahhhh
I want to then want to create a query that looks like this:
Case # Other Fields ...Leave a comment:
-
Query Question
I have a 2 tables. They are linked together by the primary key of the (one) table and one of the primary keys of the (many) table. When I bring the two tables in the query I get separate entries for each of the lines in the many table, but I would like for the fields of the "many" table to be added horizontally to all of the cases in the "one" table. Does anyone know of a way to do this? -
Build Query from One to Many Relationship
I have a 2 tables. They are linked together by the primary key of the (one) table and one of the primary keys of the (many) table. When I bring the two tables in the query I get separate entries for each of the lines in the many table, but I would like for the fields of the "many" table to be added horizontally to all of the cases in the "one" table. Does anyone know of a way to do this? -
I need 4 tables because there are too many fields for one table...Leave a comment:
-
Table Relationship and Form Problem
I have 4 tables that are linked by a unique indexed case number. I want to have a form that allows you to create a new case and enter information to one of the tables, but still create a new case number in the other 3 tables.
I have tried creating a relationship-one to -one between the one table and the rest (Case Number to Case Number. )
I then created a query that brings them all together, but there are 4 different case numbers... -
Thank you, but I get a syntax error when i place the statement in the macro run sql action?...Leave a comment:
-
Is this a filter criteria for the form, or is it a query def form?Leave a comment:
-
Problem with Macro RunSql Statement
I would like a all records from [Master Log] (a table) where [Master Log].[Disposition]="Rejected" and input those records into the [Rejected] (a table). Both tables are exactly the same as far as structure. I have created a macro with one RunSql Statement.
[Code]
INSERT INTO [Rejected] SELECT ALL FROM [Master Log] WHERE [Master Log].[Disposition]="Rejected"
[Code/]
It says there is a syntax error,... -
Hmm, maybe I want it to back up every day. and save to a different folder on the serverLeave a comment:
-
I think I will want to use SQL and select records from the table based on certain criteria, then append them to the new table, then delete them from the old? is this rightLeave a comment:
-
Might you illucidate how? I don't know how I want to do it because I don't know what my options are?Leave a comment:
-
Create Macro that deletes from one table and appends another
Is there a way to create a macro that, based on certain criteria(dispos ition status and date received), removes a line from one table and adds it to another. -
Automatic Backup
Is there a way to automatically create and save a backup database? -
-
Reference a field that is not in form, but is in the same table
Can you reference a field from the table that a form is based on, if the field is not located on the form? -
-
How to break up table?
I have a table with about 80 fields and 400 lines. I separated the tables into a database that sits on a server and all people have a copy of the access program with forms, tables, and reports on their desktop. The remote access connects to the server, it's pretty simple.
I want to improve speed.
So far, I have included onload events in a form that define the record source and set for the main source and combo boxes. ... -
Handling Nulls in a String
I have a button that when pressed on a form, automatically reads statments and inputs a text sentence, based on other fields on the form. However, the variable only gets assigned a sentence if something is true, but null if it is not true. The below code sits after all of the criteria statements. The problem is that when the first four statements are null, the field has four spaces before the sentence. This is obvious because of the " "... -
No activity results to display
Show More
Leave a comment: