473,326 Members | 2,175 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

need query..its urgent......

hi friends,

I am facing one problem...
I am using ms-access .

I have parent table with fields (empid(primary key),password,flag).and child table with fields (empid(fk),empname,date,intime,outime,remarks).

If i enter empid and name of month,the output contains fields like:empid,empname,date,intime,outime,remarks.

My problem is if i enter empid and name of month,it has to get all records of employee(holding that empid) throughout the specified month..

Please send solution for this...its very urgent.........
Sep 9 '06 #1
3 1220
PEB
1,418 Expert 1GB
How do you introduce your month?

Can you show us your SQL that you do? and the results of the SQL?

And can you give us an exemple about what are you looking for?

Have a nice day!
Sep 9 '06 #2
MMcCarthy
14,534 Expert Mod 8TB
You say the child table has empID as a foreign key but what is the primary key of that table.



hi friends,

I am facing one problem...
I am using ms-access .

I have parent table with fields (empid(primary key),password,flag).and child table with fields (empid(fk),empname,date,intime,outime,remarks).

If i enter empid and name of month,the output contains fields like:empid,empname,date,intime,outime,remarks.

My problem is if i enter empid and name of month,it has to get all records of employee(holding that empid) throughout the specified month..

Please send solution for this...its very urgent.........
Sep 9 '06 #3
ebo2006
30
Hi, Vinoda2005. Did you get a solution to your problem? Maybe you can help me, I have the same problem. Thanks.
Oct 26 '06 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: AVL | last post by:
Hi I'm working on indexing a website. I want to restict the search to only few file types like .doc,.txt and.ppt How to specify the file types in the 'ixsso.Query' object Presently i'n using...
1
by: write2ashokkumar | last post by:
hi.. i have query like this.. select id,name from tbl where id in(5,2,4,1,3); When i execute the above query.. i get the result set with ascending order by id by default....
2
by: JHNielson | last post by:
I Know I've posted an Urgent message before. But I'm in the middle of system testing, and these little stupid bugs are killing me...... I have a query that checks that a set of values (the...
1
by: write2ashokkumar | last post by:
hi... i have the table like this, Table Name : sample Total Records : 500000 (Consider like this) Sample Records: id ------------ name
3
by: Sandy911 | last post by:
I´ve never used charts in Access. Somehow I managed to format well shaped charts in Excel but I can´t find the way to understand how to create a report in Access that produces a bar or a pie chart...
6
by: martin DH | last post by:
**Urgent Need** I'll throw out the basics and any assistance is very, very, very much appreciated! Access 2003 on XP On a form (frmMain) is an option group of check boxes (ReportFrame) from...
2
by: mirzaali | last post by:
Hi All, I neeed to dispaly the data in html table tag Query :-select comp,total,funds from table1, WHICH WIL RETURN 3-RECORDSETS rs_query(0) rs_query(1) rs_query(2)
2
by: cj | last post by:
My code below gives me "SQL: Column 'BTN' is not found." It will work if I use an inner join or just join but those two joins don't return all the rows. BTN has 5 rows, but arcust01 has only has...
1
by: veerunrt | last post by:
Hi All, one column is having no of values separated by comma in the table that any one value should match with some other column of another table one value how to join in oracle I need result...
5
by: Justin | last post by:
Here's my XML: <?xml version="1.0" ?> <AppMode Type="Network"> <CurrentFolder Path="c:\tabs"> <Tabs> <FilePath>tabs\Justin.tab</FilePath> <FilePath>tabs\Julie.tab</FilePath> *****There could...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.