Mostafa;
- i can't got it ..
This makes no sense.
- i could attach the data base to make it ore clear ..
Because most of our Experts and Moderators answer posts from work behind firewalls and/or on secured PCs, attachments are not usually our first option.
Indeed, most of the time, we do not need the file. Simply providing the information in the post is enough
See this example:
Sum Across Columns in Crosstab
VBA and SQL can be posted within the thread and it is preferred that such be posted as text within the thread, not as an image or attachment, and formatted using the
[CODE/] (required) button (or you can insert [code]..[/code] tags around the text by hand) as shown in the above link. NOTICE THE DATA TABLES... the
[CODE/] format will hold your table formatting... just use spaces and NOT tabs to align the columns.
i need to make a query to make the field (Date) to be common
Simply joining on the [date] field may not be enough, as I indicated in
my first reply, the tables may need to have more than that in common.
However, it may be as simple as joining on that field... in the query design, show both tables, link on the [date] field. Because we do not have any details, all I can suggest is to try setting the link between the tables to show all the records from one of the tables and only the related records in the second. Once that is done, drag the fields from each table that show the data you are trying to retrieve in to the grid display. Run the query to see if this works.
Beyond this basic guide, you simply have not provided enough detail about the tables themselves (refer to the above link for an example for how to do this).
two tables (Cairo-CT - Cairo-INV)
The naming of the tables you've provided makes me wonder if you have properly
normalized your database.
- any body could help me ?
We do ask that you make an effort and when possible show what work you've done. This does several things: it gives us an idea of your knowledge level, it keeps us from rehashing what you've already tried, and finally it shows
"sweat equity" on the poster's part
The tutorial link in the PM I've sent you will walk you thru how to build the core query types that you simply MUST MASTER. These are BASIC skills that every database developer MUST KNOW and UNDERSTAND - hence, why I sent you the PM with the tutorial link and other resources.
++ Unless the situation is: very simple, very unusual, or unusually complex - code/sql solutions are not normally just provided on demand please see our FAQ