Hi, I have a table which has CHECKINTIME and CHECKOUTTIME fields. May I create a query that will show TotalTime check out? For example: CheckOutDate ...

Hello guys and dolls, I dont know if I'm asking this question right. But this is my first time using Access. I have 53 columns, which consist of 1 item...

I have had this error on the same machine in the past. Only the top and left 2 or 3 inches of certain reports are showing and are magnified to fill the whole...

Hi, I'm trying to insert a chart in a report in MS Access. I have a simple table like this: studentnumber:1(long...

Using access 2000. Non programmer. Syntax wanted. Field called property has bunch of information. Within field are words: B/L#. 352/53 Referee. The...

Im creating a data dictionary and have a line of code from the CmdCreateDD_Click procedu DoCmd.RunSQL "delete tblDD.* from tblDD;" it works but I dont...

Hi, I have a form which is based on a table, I want to combine the Forname and Surname fields into one so |john|Smith| would be |Smith,John| on the form, but...

I have a table which containes ddate, and number. I need a query to get only the numbers for a month depending on the max date in the table. Example if...

when I type 4 full stops, 3 full stops change to a bold "l" (not acctually a bold l but it looks like one) Anyone know why?

A2K(SP-3), WinXP A form with a Picutre frame has a subform datasheet which lists the FileName and PathName of each photo for the user to select. When the user...

I have a very simple query which just looks up a description and location. In criteria I put but I have to spell it out in order o get data back. expl. If I...

Hiuy I have just posted this on the databse discussion group... However i am a novice at anything...... .... I have just downloaded a template from office...

What happend to this site: http://support.microsoft.com/ I used to go here, click on Newgroups at the top, click on Windows, XP and then post. It was simple....

I have a form that I want to restrict access to. I only want it to be open from another form and NOT from the DB window. The other forms change the recordset...

i need to organize a bout 2000 vynle 45 records and i need to alphabetize them by artist then with 2nd heading under artist for songs by said artist

We are upgrading from WIn NT to XP. THe XP Pro is being run under a VNWARE Image. Two problems have emmerged 1. Access 2003 WIll not directly convert an...

Doug's reply was helpful, but as a new Access 2000 user, where do I code this? I have searched the help for "IF" but can only find the "IIF" statement which...

I am trying to input my inventory with access and it will not let me put in my own product id # it continues to use an automated #. How can I get it to use my...

I rarely use the MS Access UI but I just now created a table named Table1 in MS Access and I got a message saying, "A table must have a primary key for you to...