Thank you for responding. However, the report is actually based off of two tables. The fields are already in the tables and the tables are linked. Any thoughts for this scenario?
I created a report using the report wizard. At that time I didn't anticipate needing another grouping by a field I hadn't chosen in my report. Now, I can't get the additional field to show up in the sorting and grouping area. Does anyone have some advice on this?
Thanks
Does anyone know how to run an update query from a macro (or any other workaround)where it doesn't stop the process to say "You are about to run an update query that will modify data in your table" and then "You are about to update 3 row(s)"? In other words, I want the...
Thanks. However, nothing seems to happen. When I change the current workforce number, the textbox field changes to the correct number, but when I look at the table, it hasn't put anything in the EMF field.
J
I am not sure what it is you are asking for. (Like I said, I don't use access or VBA for that matter much.)So here is what is in the text box.
=EMFCalc([CurrentWorkforce])
and as I understood it, the code up at the top of this post was the function. If it isn't, let me know and let me know...
jbehrne,
Thanks for responding. No, the code works just fine and it gives me the result in a text field. However, I need to put this calculation into the EMF field in my table. Any thoughts?
J
Hi,
I am a only an occasional user to programming in Access so I really don't know much about the code area. I have been banging my head against the wall for some time now. This code was modified from a totally different database.
I have a form that has a calcuation in its code shown here...
Go into the properties of the graph and then into the row source property click the ... button. This puts you into the query for the graph. Go into the SQL statement design view and when it says Select blah, blah, blah as [your legend description here]then look at your report.
Hope this helps.
Oh No! Mr Bill. (Like you haven't heard that a million times):)
The problem is that the memo field isn't listed in the equations.
dgillz,
I had manually put the field in the equation editor. I had two records that should have showed up with "not isnull". Only one did. The other...
Hi, I am using CR 8.5
I am trying to work around the fact that I cannot access a memo field in the Equation editor. So my plan is to put the memo field in a section of its own and then click suppress if blank. My question is can I reference that section in an equation? Something to the effect...
I have set up my database so that each user has to log on as themselves. I want them to be able to "accept" a record as their own by clicking the "I accept" button which would put their userID in a field.
Does anyone know how to put the user ID from the log on screen into a...
Hello,
I have a program that populates my access 2000 database. When a record is added to a table, I need a way to send an alert to the person responsible for that information. It is my intention to just leave access up and running on a separte machine. I am sure this is possible, but I am...
First let me say that I know next to nothing about Citrix. Otherwise, I am fairly computer savy. What I would like to do is do the citrix equivalent of the dos Copy command
copy C:\blahblah\blah\*.blah Citrix\blahdirectory\blahdirectory
I am trying to upload some reports to the citrix...
Hello,
When I run my crosstab comparing a table with ONLY dates in a field with another table containing dates with timestamps, my query does not return the records that had timestamps with the date. I more or less understand why it does this, but I can't seem to convert the field to something...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.