Lukket

Loop code

I am just starting out using VB in MS Access. I created a program that can count personal and vacation day requests at my job. I can write the SQL for the queries but I can'y seem to figure out how to connect the SQL through a form using VB. I want the program to count the number of people that are off on any given day.(I wrote the code that gives the initial approval) I do not want that number to exceed 10% per day per department off. I guess I have to create some variables and then loop them? That is where I get stuck. I'm using this program for a home work project for night classes at college (Due in 1 week) Any help would be apppreciated Jim

## Deliverables

All I need is the code, I can paste it into my project and hopefully line up all the variables. I'm just getting constant syntax errors. ie: count people that are off on 7/24/2003 (or any other day) use a counter to count up to 10% of the people working that day. Approve requests up to 10% and deny the rest grouped by employee, department, and shift Thats it

## Platform

MS Access 2002 XP Windows NT

Evner: Ingeniørarbejde, Microsoft Access, MySQL, PHP, Software Arkitektur, Software Testning

Se mere: vacation work engineering, vacation engineering, stuck at work, nt job, job on line engineering, job nt, job in nt, how to write vb, how to write code, how to get a job out of college, code line, write some sql for a project, using rest access, write sql queries, create code access, program college project, use code access, help access code, sql syntax, sql project college

Om arbejdsgiveren:
( 0 bedømmelser ) United States

Projekt ID: #2904559

20 freelancere byder i gennemsnit $25 på dette job

finecodervw

See private message.

$8.5 USD in 14 dage
(155 bedømmelser)
6.2
gr8solutionsvw

See private message.

$21.25 USD in 14 dage
(14 bedømmelser)
5.0
timk98

See private message.

$17 USD in 14 dage
(54 bedømmelser)
4.7
byzasproduc

See private message.

$12.75 USD in 14 dage
(42 bedømmelser)
4.3
christopherayers

See private message.

$85 USD in 14 dage
(47 bedømmelser)
4.1
nhdyer

See private message.

$8.5 USD in 14 dage
(10 bedømmelser)
4.2
louischarle

See private message.

$11.9 USD in 14 dage
(22 bedømmelser)
3.5
techjunc

See private message.

$5.1 USD in 14 dage
(21 bedømmelser)
3.6
nerd82

See private message.

$11.05 USD in 14 dage
(10 bedømmelser)
3.4
mcpnet

See private message.

$21.25 USD in 14 dage
(8 bedømmelser)
2.8
vw724304vw

See private message.

$34 USD in 14 dage
(4 bedømmelser)
2.4
ravindra2vw

See private message.

$17 USD in 14 dage
(1 bedømmelse)
1.4
vw631999vw

See private message.

$34 USD in 14 dage
(2 bedømmelser)
0.7
vw691840vw

See private message.

$8.5 USD in 14 dage
(1 bedømmelse)
0.2
jamesbragg

See private message.

$8.5 USD in 14 dage
(0 bedømmelser)
0.0
sentientpc

See private message.

$42.5 USD in 14 dage
(0 bedømmelser)
0.0
echobravovw

See private message.

$12.75 USD in 14 dage
(0 bedømmelser)
0.0
bdetarade

See private message.

$85 USD in 14 dage
(0 bedømmelser)
0.0
bobcoder

See private message.

$17 USD in 14 dage
(0 bedømmelser)
0.0
tugood

See private message.

$42.5 USD in 14 dage
(0 bedømmelser)
1.4