Search results

there's no real relationship. the "ballotID" is arbitrarily assigned to each row. Basically, on my forum which this is using, it takes different factors into account first it calculates post count, time on the forum, and then lact activities. It then calculates how many ballots those members...

thanks john, that gets the data to a table. i just still havning the issue with spreading the data out to thenew format i want and Aje, i'mhaving a hard time understanding where you want that run

that would be assuming i even knew what that was which apparently i dont

I have a complex dilemna, for me at least. I need to create a table based on a query i have created. the Query has the following information UserID ----- Ballots 1 --------- 1 2 --------- 2 3 --------- 1 4 --------- 3 5 --------- 1 from that query it would output this directly into a new...

Thank you missingling, this provided the necessary result. Sorry for the delay as other "important" work always comes up

I have a combo box that is part of a form that executes a specific query. The data is taken from within a datasource I cannot edit. However I need it to insert a NULL value option into the combo box The form works that the user selects a Branch location from the combo box. However, I want it...

thanks bob, I'm not aware of the excel COM module though. I'll need to look into it

Hi Y'all. Long time no ask, But hopefully you can help me on this. I've got a report written. looks good. Works good. Everythign is exactly as I wanted it. However the question is now they want it exported to Excell format. But the kicker. Each page must appear in the excell spreadsheet as a...

Gemma, you've hit a few nail's on the head so to speak. Im not developing a payroll system, But using Access / SQL2005 Report Writer to write a series of detail reports for our existing accounting package. We are using Microsoft Dynamics Great Plains. While it is very powerful and does a lot of...

The report I'm creating has some duplicate values that are interfering with the data output. I need to somehow fix that! it would be best if i could do a sum of values in textboxes rather than the query. Here''s the query i have. TEMPID ----------- DATE -------- TYPE ------- hRS --------- CPP...

This gets even more confusing as I go. Two tables again needing to be joined. But only need to fill the data in the first line.... yes, Pain in the ARSE> here's a sample. PAYLINES TABLE EMPLOYEE --------- DATE -------- Paytype 121614000 -------- 12/31/2007 --- 300 121614000 --------...

Ok, The data is populated by a 3rd party application and the data is non writable in the query side. However, you will see in the tables Table 1 Date -------- JOBID ------- EMP# 01/30/2007 --TOR455-01 -- 1000 Table 2 STARTDATE --- End Date ----- JOBID ----------- EMP# --- Recruiter...

Wierd Join needed... Here's my problem. it's been bothering for a bit... I have 2 tables, one with a date, and the 2nd table with 2 dates. I need to only pull the records from the 2nd table where the date in the first table come between them. TABLE 1 DATE JOB# EMPLOYEE# TABLE2 JOB#...

absolutely is! this is where you would build your queries. Once the data is entered, when you start using it, you'll be amazed at the options you can do. for example, in this case, you would build a new query with a column that opens a switch statement that says if it's a certain age, it...

Yes it is possible The xbox 360 comes built in with whats called a Media Centre Extender. Xbox original had one you could buy with remote for it. It will connect to your PC and load Mp3's, Video's and pictures from your "My documents" folder and allow you to play them on your Xbox360. This...

if you have an ipod, there are always options. I have myself the G5 ipod video with about 4000 songs on it (far from full i know). And nothing is better than having the option to listening to whatever I want when i want (I also have satellite, but thats a different story). I found, a device...

boblarson. as always you're quick to respond and respond you do with the correct solution Thanks again!

as the above have stated. There's a lot more to it than just simple databases. There's the front end, the design that users see, idjit proofing and then worrying that the back end works as well. most web pages you see that use data functions these days use a more advanced programming language...

Seems simple i would think. Two reports one for multiple clients, one for just a single client. I want to do it from 1 page, but with one button (for idiot proofing). The entry page has inputs. a beginning client and an end client. the if statement should check to see if they're the same. if...

I'm so full of questions today! I have a form with multiple list boxes. you select a value from one and the form further populates another, and so on and so forth (there are actually 7 of them!!!!). They work great for giving a nice dirty list of data when you want it too. However, one of my...