Exporting a query\VBA (Im not sure which to use) to csv

[shabbaranks]

Hi Guys,
As the title suggests Im at a bit of a loss as to where or how I achieve my goal. What I have is a table which consists of Activity, Project, hours (which can be negative), description, code and username.
Those entries within that table represent a number within a different table. How do I produce a query which will output the corresponding column data and also join two fields as well. A more descriptive explanation:



I start with Activity, project, hours, description, code and username and I would like
AB if the hours is positive AD if the hours are negative, PP-XXX - where PP is the corresponding field of Project entered and XXX is the corresponding field of the activity (outputting a joined result), code which is in the table as its entered, and also set a standard entery for 4 other fields.

Im guessing this probably doesnt make too much sense so if I need to elaborate a little please say so. Its difficult to pertray what I mean.
Thanks in advance

[hertfordkc]

I gather that you want two different columns for hours, one positive and the other negative. That can be handled with calculated fields.
From your description, query design should be able to handle the setup. From there, you could get the SQL if you need it.
How about trying the query design and post the resulting SQL if you get stuck.

[shabbaranks]

Kind of, I have an hours field which users enter into. This has a switch to convert the number from a positive to a negative. If the number is positive then I would like to output AB and if negative then AD.

I am trying the query design to get things going - I dont suppose you know why its duplicating the results? I have 3 columns repeating themselves whilst there are only 2 entires in the table. My the sql is below if that helps?

SELECT TimesheetTable.sUser, TimesheetTable.[Task Date], TimesheetTable.Description, TimesheetTable.sCostCode, TimesheetTable.Hours
FROM TimesheetTable, ProjectsTable;

[hertfordkc]

Kind of, I have an hours field which users enter into. This has a switch to convert the number from a positive to a negative. If the number is positive then I would like to output AB and if negative then AD.

I am trying the query design to get things going - I dont suppose you know why its duplicating the results? I have 3 columns repeating themselves whilst there are only 2 entires in the table. My the sql is below if that helps?

SELECT TimesheetTable.sUser, TimesheetTable.[Task Date], TimesheetTable.Description, TimesheetTable.sCostCode, TimesheetTable.Hours
FROM TimesheetTable, ProjectsTable;

any calculation for the positive/ negative numbers.
The duplicates may be the result of the lack of join information. I expected that you would show some fields being selected from each of the tables, and an equality/non-equality statement (a WHERE clause ) specifying the join.
Are there any established relationships between the tables?

[shabbaranks]

There arent any relationships between the tables, I thought I needed a relationship but I read somewhere that you dont as you can do the reporting by joining? Not knowing a great deal about this I wasnt sure?

The positive negative numbers I didnt have a clue how to setup but thought I would attempt getting somewhere first?

Thanks

[hertfordkc]

If one of the tables has a key from the other table, you should define the table relationships IMHO.
Without that and with no join info, I'm not surprised that you are getting duplicates.
As to the positve/negative numbers, I can't tell whether that should be part of the query or should be addressed in a form or....