Search results for query: *

PH: Thankyou so very much for your suggestion. I changed all CompanyName references to CoName and adjusted the math to work for "negative" open positions and it works!!!! Thank you again - Azhutch

I still cant get the query to work. Can anyone Help?

Skip: Not a problem I made a copy of the query and replaced the SQL to see if it would work. Both Ticker and CoName are fields in the tblTransactions table. I am trying to get a FIFO inventory of open security positions which I will then use to calculate realized gains/ or losses and also an...

Sorry for the delay. I replaced my SQL for the first "pt SELECT" statement with your suggested SQL. It returned "Syntax Error in Union Query

Skip: thank you. I am trying to set these to zero. Can you help me with the code to do that?

Can Anyone help me with finding where I have made the following error "The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect." in the query statement: SELECT a.Ticker AS Expr1, a.CoName AS Expr2...

MaZeWorX: Thank you it worked like a charm.

I have an Access database that registers individuals to a conference. I need to print a name tag as each attendee registers for the conference. I have been able to limit the records by using a [Lastname] criteria in the query, but when there are multiple last names, the report prints name tags...

I have a table of home games for a little league team with gamenum, date, teamname and teamlogo as fields. I would like to populate the team name and logo on the respecitve dates on a calendar control I am using in a sub-form. Can anyone please help? Thanks

I placed the following suggestion to my question "Adding a new record with fields from an old record. which suggested I place the following in the After Update Event Procedure "Me![combo name].DefaultValue = Me![combo name]" which I did in Access 2000. I substituted the name of the combobox - ...

Paul, I tried this in Access 2000 format and I received an error "the object doesn't contain the automation object "me". Sorry to be a bother but could you help! Thanks

How can I have the combo box show the last record entry in a new entry. I have several selections and typically I will use the same selection over a series of records.

Bob: Go to Sorting and Grouping Options for the Detail Area of Your report. For the Date Group Click on Year and see what happens.

I created a report that displays daily information that is summed up on a month to date ( over group ) and year to date ( over all ). The methodology worked well until the year changed and the year to date column still obviously sums up all of the records regfradless of the date. I need help can...

I am trying to use the Over All property on a Microsoft Access Report which provides daily information that spans over two years. The Report has headings Today, Month To Date and Year to Date. I use the over group property for the month to date information which works well, but when I go to the...