Search results for query: *

Hi all, I am getting more and more confused and I thought I knew Access :) I have a master list of all student ID's which is the primary key from that table. I have left joined that table to the grade table (which has student ID's, grade and date). I want all the students to return a grade for...

Hi all, I have 100+ students that can come at any time during the week and turn in a report. I then enter their mark in my Access DB. However, some of the students don't show at all. I can find out who they are by querying from a master list with 'null' in the report field, but I would like...

I am drawing a blank. I have a calculated field in a report giving a currency readout (2 decimals). However, there are more then two decimals when it calculates it. I forgot where to go in the table or the query to require that the raw data is also two digits only. I.E. I have the amount $23.15...

I have a report that goes on a pre printed sheet where several boxes need to be marked. Unfortunately, the option group is not good because I need specifically 'X' in the box instead of the check. Does anyone know of a substitute method to use? Thank you David

Sorry if this is the wrong forum, but I need to break down an amount in a report I am writing. Let say the amount is $1,045.34. I want it to read only the 1045 and then the 34. What is the format command for that please. My Textbox will look like 'The amount of '&[whole]&'dollars and...

I have a report where if the value of salary is >0, I want it printed on check paper, and if value = 0 I want it printed on regular paper. I have 70 records in the report, with one page per record. Where do I specify the batch request and can I request both at once? Thank you

In the detail segment of a report, I am using the NZ function to generate 0 when the field is actually null. Lo and behold, I am getting some results as #errors while other display correctly...duh! My assumption is to create the text box and write =NZ([fieldname]). Am I missing something? Thank...

Good day all, Would anyone tell me why, in a report, when a text box has a control source and a name, I can sum the controlsource and not the name? If the control source in the table is called TOTAL and I give it the name txtTotal, why can't I get another unboud textbox to be =sum('txttotal')...

Have no idea how hard this is or if it can be done: In my table credit, I issue an amount linked to a person via a form. For example, in frmCredit, I have employee number, amount and date. Once I fill the record, I would like a record to be filled in table debit with the same employee number...

Hi folks, Don't know what I am missing. I have a function in a module that calculates the last sunday (i.e. if today is Tuesday the 6th, it will return Sunday the 4th). I am now trying to apply this function into a query. I have a field called inputdate that writes the date of the entry in the...

Hello, I would like to generate on a weekly basis an automated billing schedule. For example, I have 5 rentals (room01 - room05) that are rented weekly to the same people (john, wilson, karen, doug, brian) for the price of $10 weekly - every week it is the same exact info. Rather then entering...

Genius that I am, I removed the menubar when I installed a switchboard on the Startup screen (in the startup menu, you hav teh option to remove). I now do not even see the Tools menu to try to bring it back. Any one know how to do it? I really need them because I am trying to make a change to...

Hi, I have seen this before, but don't know where. Went to search and Faq's, but didn't find it. I have a field in my report that shows the name of the person. I only need the first letter. Could someone please remind me what the function is? Thank you David

HI, I am new at this, so I apologize if stated poorly. I have a new price chage for my taxi route. So I will use the Dmax function. The two important fields are [dateinput] and [startdate]. They are both date fields. I am getting lost in nthe criteria section with the single double # etc... Is...

Hi, I am very new at this, and hope someone can help. I have a query that gives me the price of the taxi fare depending on the route. It also logs the vehicle number. Unfortunately everything works except the fact that if a taxi did 10 fares, under the count function for the total, it counts...

I have in my report a date control whith the format ww for Week number. Because my computer must be based on Sunday is first day of the week, the week number is off by 1 week (the first Sunday of the year, 01/04/04 displays as week #2). Can anyone tell me where to go to change that? The Faq's...

I am sorry to be so obivous, but I can't get a cal. field in a query to work. I want Price: [rate]*[quatity] And [customer]=1 I have tried with 'And' and 'Where' it keeps on rejeting it. Sorry for being so obivous, I don't understand what I am missing. Thanks for the help

I have a total (it sums a few records) at the bottom of a report. I want this number to become a value in a table that I would call Invoices to be paid. That way I could make a check box next to it and cross reference it. This is obvious in excel. I am new to Access, and I don't see how this...

I am a total newbie, so I am sure this is more then basic, yet I can't figure it out. I have a table of truckroutes (truckroute# [primary key], origin, destination, miles, gallons...). Each route has a price. If I include the price of the route in the truckroute table, when i will change the...