Search results for query: *

I am working with one table that has a field indicating: FiscalYearEndMonth, UnitName, LocalUnitType. I need to get a summary information by fiscalyearendmonth and localunittype. I'm not certain how to get this aggregrate information.

Awhile back I was getting help with what I call some complex queries. While most of the issues were resolved at the time, one was not and its resurfaced. In reference to thread 701-1351569(last couple posts) I have a query: SELECT A.LocalUnitCd, A.LocalUnitType, A.CountyCd, L.LastAuditDate...

I have a form which I was in the process of adding several new buttons to, now no matter what button I click on I get the following error: The expression ONCLICK you entered as the event property setting produced the following error: Ambiguous Error Detected, Cmd8Click What does this mean?

I have a form I created, with a field that I put in as a calculated-read only, run-time property set to current date/time. While it does display on the form as it should, I was hoping to have it come through with the other fields when the data file is sent, however it does not. Does anyone...

I'm still trying to resolve this issue. I'm trying to import a simple xml document into access. At the access end, I'm selecting "get external data", highlighting my xml file, and clicking ok. I then indicate to import "structure and data" however I only end up with the structure. Can anyone...

I have a file being received from a user that is in .xml and when I go to import the document into Access, it only imports the structure, no data. I am selecting the option to import both data and structure but I'm not getting any data. Any ideas what could be wrong? <?xml version="1.0"...

I've not worked with Access Pages much, however I thought users could edit or enter new data into a page. On my page the buttons are greyed out to add a new record or delete a record. I wanted to create a page so users could use it to input data into our database, instead of having them...

I've not worked with Adobe very much but wondering if there is a way to work with the data from forms that are scanned.

I'm working with a table that has the following structure: [autono]pk [quest_num]pk [quest_yn] [quest_weight] The table holds a yes no reply to a series of 15 questions. Each question has a certain weight factor. later. I need to be able to perform 2 task. The first is to come up with a...

Hi, I have a series of 10 update queries that I need to run upon completion of a form's data entry. Currently when it runs its updating all records, but at this point I only need the queries to update the current record. How do I tell each query to only update the current record that was input?

I have the following query that I am running, but what I want to do is only display the [UNIT NAME] field once, but list each of the replies in the [QUESTIONS_MAILOUT] field. Can this easily be done or done with the start I have? SELECT [AUDIT REVIEWS].[UNIT NAME]...

I have not used the replace function in Access and need to take a field which is in this format: .Beaver Township and create a new field with only the word: Beaver Can anyone help me with this?

I have this simple query: SELECT DISTINCT [Registration AACO 2007].State FROM [Registration AACO 2007] GROUP BY [Registration AACO 2007].State; But I need it to tell me also a count of the number of different States. I don't know how to get that into this??

Good morning, struggle to establish proper relationships. tbl_survey surveyID pk surveyName tbl_questions questionID pk surveyid fk question tbl_answers answerID surveyID questionID answer Question: in my tbl_answers what should my primary key be? combination of the three ID fields?

Earlier I posted in the queries forum, and it was suggested that what I'm trying to accomplish might be best done through Word. I just want to see if anyone can see another way. I have a form, which is like a survey with several questions (labels) and a corresponding yes/no field for...

Here is what I need to do and have no idea really where to begin. User has a form set up with several yes/no questions. For each question that is being answered YES I need to place the corresponding questions into a letter. The letter will have an intro paragraph that explains why they are...

I need some help here. I have been asked to create a query that I'm not sure I can do it. Its working with 2 tables that are not related. Table 1: Dbo_LocalUnitAudit PK ID, other fields include: [CountyCd], [LocalUnitType],[LocalUnitCd], [FiscalYear], [AuditReceivedDate] Table 2: Audit...

Hi, I created a report in Access which some lines that make the report look like a table with columns. However I want to be able to export this without losing any of the lines. Is this possible?

Good morning, hoping someone can point me in the correct direction. I need to produce a letter based on the users reply to several yes/no fields on the current form being completed. For example: If field [APR] = No then I want a certain paragraph to print out on the letter. The form consist...

Good morning. I have to fields I need to join in a query, but one is in the date format of xx/xx/xxxx [FYE] and the other just as year xxxx [FiscalYear]. How can I change the FYE field to the year format only for the purpose of running a query?